Programming SQL

how query Active Directory from sql2k server?
I've seen this linked server syntax many times in the group. but it didn't work for me, maybe someone can explain it better for me? sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource' i know that: * " ADSI" is the server argument, which will be the name of this... 8 Mar 2005 12:19

IO is thawed/frozen
Our SQL Server 2000 has had the following 2 messages show up in the SQL Server Logs in last 2 days. IO is frozen for snapshot IO is thawed. Can anyone give me any information/cause on them? Thanks. David ... 16 Feb 2005 12:23

Select distinct
I have a query but when I order by one of the elements I get this error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. /BlueDot2005Beta/Intranet/Reports/Advanced/Re... 16 Feb 2005 12:23

Dead Lock Again
We are encountering some deadlock problem with our SQL2K (SP3) running on Win2K SP4. When turning on the traceflag 1204, we obtained the following log records: It appear that is some resource contention. How do we move from here? Please help. Thanks in advance. 2005-02-06 13:01:50.70 server ... 16 Feb 2005 06:47

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

Dropped or missing newline character
I imported MySQL tables into an Access MDB and confirmed that the Access table preserved the embedded new line (0x0A) characters within a memo field. I then used an Access append query to insert data into a linked MS-SQL 2000 table consisting of an NTEXT field. The embedded newline characters were dropped. W... 15 Feb 2005 13:40

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

Week no query
Hello I'm looking for a query which can select and group by week no I have query for a SQLBase which gives me this but I cannot translate it to MSSQL? select Some_Date, (@weekbeg(Some_Date) - @weekbeg(@date(@yearno(Some_Date), 1, 1))) / 7 + 1 as Week_Number from Some_Table; Here's an example where I ... 12 Feb 2005 17:12

PRB: Single Query to build database and schema.
PRB: Single Query to build database and schema. Please help, I'm quite frustrated with a problem. I want to issue a SINGLE query to completely build my database (IF IT DOESN'T ALREADY EXIST), "use" it, build an entire schema of tables, stored procedures, triggers, and even populate tables with data. Envisi... 12 Feb 2005 17:11

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