Using MS SQL Server

SQL 2005: Renamed 'sa' account
We have renamed the 'sa' account on a SQL Server 2005 machine. When we run SELECT * FROM syslogins it appears that 'sa' no longer exists as a valid SQL login. However, when we look at running processes through sp_who, we see that 'sa' is still being used in various background operations, even when we shut d... 9 Apr 2008 20:24

MS SQL Stored Procedures , Visual Studio 2005 , "Input values cannot be converted"
A few people in the DOT NET world have noticed that when stepping through SQL stored procedures using Visual Studio 2005, when debugging, an error can occur. This bug occurs if you try to call a stored procedure that uses a BIT type of Parameter. The error message "Input values cannot be converted" occurs , as yo... 6 Apr 2008 23:25

Client side insert update
hi friends; I have problem about sql server insert and update in client side. I am coding windows application with c#.When I run my code in database server computer all is fine.I can see data, insert and update.But when I run same code in client side I can see data but not insert not update what can I do about thi... 7 Apr 2008 07:01

help,a regular text file how to sql 2000 table code ?
agiler (sulichun(a)tom.com) writes: help,a regular text file how to sql 2000 table code ? i have a text file as follow, line with ��|��and {LF}, 8|-000000186075919.|+000000000387820.|2008-03-31|20010423| 9|-000000000003919.|-000000000123620.|2008-03-31|20010123| 8|-000000018623419.|+000000000... 5 Apr 2008 18:49

Convert rows to columns
Dear All, I want a list of selected orders and the orderproperties as columns but the properties are stored as row in table ORDER_PROPERTY (only 1 row per order !) Table: ORDER: ORD_ID, ORD_CLIENTCODE, etc Table: PROERTY: PRP_ID, PRP_NAME, etc > don't think I need this table for my view or SP. Table: ORDER_P... 5 Apr 2008 12:05

help,a regular text file how to sql 2000 table code ?
help,a regular text file how to sql 2000 table code ? i have a text file as follow, line with ��|��and {LF}, 8|-000000186075919.|+000000000387820.|2008-03-31|20010423| 9|-000000000003919.|-000000000123620.|2008-03-31|20010123| 8|-000000018623419.|+000000000381230.|2008-05-30|20010423| i want to s... 5 Apr 2008 09:50

Yellowfin discusses Consolidation and its impact on the Business Intelligence Market
The past year has seen a huge amount of activity in BI Tool consolidation. We have continued to comment on this activity but now at last we have the release of a Gartner Report that comments on these changes and spells out what this means for the industry and BI customers as a whole. According to Gartner the bus... 5 Apr 2008 01:12

Strange Access Query Behavior with SQL Server
Greetings, I've been trying to optimize the performance of the queries in an Access 2007 front end that utilizes SQL server for all tables (linked). The application runs fine without error. However, when I run SQL Server profiler it clearly shows that every entry in a continuous subform results in an explicit,... 7 Apr 2008 10:24

multiple process multiple threads read/write to a table
if i created many processes with multithreads writing and reading to my single SQL table every half a second or a hundred miliseconds, can the server still perform well as it supposed to under such a situation? Any limitation to this? ... 4 Apr 2008 13:31

Problem Connecting .NET app to SQL Server
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is ... 4 Apr 2008 15:45