Programming SQL

Timeout expired
I'm having trouble finding the cause of the following error message: [Error#: -2147217871 Description: Timeout expired (Source: Microsoft OLE DB Provider for SQL Server)] The error is occuring when trying to execute a simple update query: UPDATE merchant_billing SET billing_last_billing_date = '2/15/2006' WH... 17 Feb 2006 09:11

database object hierarchy
Hello: In my SQL Server databases I have complex related tables and views. There is any tool which allow you to see (print) this complex hierarchy of views and tables as hierarchical tree? Thanks, GB ... 3 Feb 2006 12:25

Unmanaged code from SQLServer 2005 CLR
Hi, I am trying to write a C# user defined function in SQL Server 2005. From there, I have to access a dll that was written in unmanaged C++. I do not think that I can use dllimport since I need to create objects from that dll. So I created a C# wrapper for the work that I need to do with the dll. I then a... 12 Feb 2006 21:42

sa password rules
SQL Server 2005 rejects empty or very short sa passwords. Where can i read formal definition of sa password rules. I writing setup application which will install SQL Server Express in command line unattended mode. So i need to check sa password for its stronginess prior to passing it to SQL Server's install... 25 Jan 2006 09:03

SQL 2005 Mirroring Databases
Im having trouble rying to mirroe a test database from one SQL2005 Server to a second SQL2005 Server I created a test database on SQL 1 ( server 1 ) and mad a full back up . i did a restore on SQL 2 ( server 2 ) through Management Studio and set the recovery option to RESTORE WITH NORECOVERY. when ok the res... 18 Jan 2006 11:51

Convert varchar to datetime
Hi, I have what seems to be a simple issue, yet I can't get it to work: I have a table that I have imported into SQL via a .txt file , one of the fields holds a date (which was originally in the format of '122499'). I added, based on certain criteria a '19' or '20' in front of the year to make it '12241999... 14 Sep 2005 15:12

Query LDAP user group membership from SQL Server
this is driving me nuts! all i want is a simple list of groups and members for each group in Active Directory. I read numorous postings on this topic and no one seems to know how to query it from sql server directly. why can't Microsoft provide some kind of schema (views) for that? i can issue a query like thi... 22 Feb 2005 09:33

Table Spool/Lazy Spool is a symptom of what?
i see a Table Spool/Lazy Spool operation that is turning 20,879 rows into 34,512,987. And then after a Nested Loop/Left Outer Join to 1,653 rows, it is turned into 1,653 rows. My question is, what is the Table Spool/Lazy Spool trying to do? To help explain my question, i can give a similar example. i know wha... 18 Feb 2005 14:44

How to use CDO to send mail with attachment
I have a stored proc thats basically a copy of the script from MS to create sp_send_cdosysmail. This work fine using our mailrelay, but there seems to be no clear way to add an attachment. I've tried a simple: EXEC @hr = sp_OAMethod @iMsg, 'AttachFile', NULL, @Attachment but that just causes an unknown name ... 3 Mar 2005 16:34

Errors with linked server
We have a scheduled job that is running on a server, which gets the data from other linked server using SP. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize returned 0x80004005: ... 12 Feb 2005 17:11