Programming SQL

Timeout expired
I am getting this error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." And this error pops up in 30 seconds. Now the Sertver timeout is set to 600 seconds or 10 minuted yet this is timing out in 30 seconds. Any ideas how to extend the timje... 17 Jul 2008 18:55

Stored proc issue after converting from Sql Server 2000 to 2005.
Hello, I recently converted a Sql Server 2000 database to 2005 (using the copy database method). After conversion, all of the stored procedures executed just as they had before . . . no problems. I have run the following issue, however . . . Although the following stored proc executed as expected followin... 18 Jul 2008 10:18

Trigger to insert column value
Hi I am new to triggers. I have checked the syntax of triggers but it is very complicated for a newbie like me. What is the syntax of a trigger that will once a new record is inserted into the Contacts table, sets the value of the column 'Company Type' to Client in the inserted record? Thanks Regards ... 17 Jul 2008 15:49

sproc question
In a sproc I need to issue a select, it returns five columns and always only one row. I need to pass those five values back to the calling proc in output parameters. Any of the five values could be Null. How do I do this? My 1360 page book (Wrox) does not show me. All the examples have ony one output parameter.... 17 Jul 2008 13:45

Question on triggers for our audit tables
We have several versions of our database: OurDatabaseDev OurDatabaseQA OurDatabaseUAT OurDatabase (Production) Furthermore, we have separated our audit tables in separate databases: OurDatabaseDevAudit OurDatabaseQAAudit OurDatabaseUATAudit OurDatabaseAudit (Production) We have ins... 18 Jul 2008 11:20

Schema comparison of two databases
Visual Studio database edition's schema comparison tool does a good job of identifying all differences between two databases. How do I go about doing this schema comparison directly in SQL server 2005 or 2008 and without the Visual Studio database edition? Thank you, Omid ... 17 Jul 2008 16:51

CTE Query
Hello all, I am trying to write a simple CTE query in SQL server 2005 as below: WITH TPAIPCTE(PIN, PINCount) AS ( SELECT PIN, COUNT(PIN) FROM DR_DetailRecordIP WHERE TaxYear = '05' AND Installment = '1' GROUP BY PIN ) The abvoe quey generates the following exception: Msg 102, Level 15, State 1, L... 17 Jul 2008 13:45

Connection Status
I have a table with the following information/columns: ServerName UserName PWord ConnectionStatus I want to write a SQL script that will test the user connection with the information in the table and update the ConnectionStatus column with a zero (0) if the connection is successful. I am basically trying t... 17 Jul 2008 16:51

How to display free spaces after massive truncate.
I have a db which about 417 gb, after I did some archives and truncate bunch of tables. I was able to save some spaces but still showing 417 gb on GUI. Is there a command that I need to run to show free spaces. Thanks. Here is the information when I run the sp is return correct but the gui is not showing ... 17 Jul 2008 12:43

Duplicate columns across 4 columns
Hi, We have a table called Clients that allows up to 4 telephone numbers to be entered. I am trying to write a query that will identify if another client has the same telephone number. I need to look in any of the 4 fields. E.g. If Client 1 has a tel no of 555555555 in TelNo1ID column and Client 2 has a t... 17 Jul 2008 14:47