How are you creating a table?

There is a drop down in Query Analyser that will probably say master.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

cluster size and allocation unit are the same

stripe set is the set of disks used in an strip array.

stripe size

Here are some good articles

http://searchwin2000.techtarget.com/tip/1,289483,sid1_gci804291,00.html

http://www.storageadmin.com/Articles/Index.cfm?ArticleID=2797

The later suggests that a stripe size...

duplicate see

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7594&FORUM_ID=9&CAT_ID=1&Topic_Title=xp%5Fcmdshell+to+create+a+text+file%3F&Forum_Title=General

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

MS has some really good papers now on how to secure servers

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bestprac/bpent/bpentsec.asp

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Fully qualify your tablename

exec master..xp_cmdshell 'osql -Q "select batnbr from yourOtherDb..xtemptable" -O"c:\test.txt"'

or use the -d switch to specify the database to connect to.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The return value of xp_cmdshell is the dos errorlevel value. If you want the results from your file in D:\MSSQL\JOBS\sub_key\qry1.txt you can return this output into a table.

i.e

CREATE TABLE results...

This generally occurs when the application is using a dll that has been upgraded or the client tool has been upgraded but the dll hasn't.

Try reapplying your latest service pack.

Simon...

You would need something to kick it off, but can't see why a scheduled dts package couldn't do it.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Could you try a static lmhosts file for the pdc so the server knows where to go.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Because SQL Server files are created in large blocks and SQL Server handles the pages within the file, I believe that their is little difference but you are probably best...

sp_msforeachtable 'REVOKE ALL ON ? FROM role'

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The SQL Server Service has be configure to use an NT account that has access to that network folder

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Do you want to run the exe on another server or run it from the other server. If the user account SQL Server is running with has access to that...

I think the issue of NULLS is also a problem.

To be able to compare NULLS in an = clause you have to use SET ANSI_NULLS OFF

Have a look at "NULL...

sp_attach and sp_detach are the supported mechanisms for doing this.

You can't detach master.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088