The Following is from BOL, under ISQL, "

isql Utility

The isql utility allows you to enter Transact-SQL statements, system procedures, and script files; and uses DB-Library to communicate with Microsoft®...

To answer my own question:

Yes SQL 2000 can run as a default instance in a Cluster, see BOL below.  Only Named Pipes and TCP/IP are available on a clustered instance:...

Yes, as long as SQL is loaded in the same location on both servers (IE the BINN and Master, MSDB, and TempDB are in the same drive locations on both...

You may want to try using an OSQL window to run the SP, then redirect the output to a file.

for example:

execute('MASTER.DBO.XP_CMDSHELL ''OSQL -U UserName -P ' -|- @PASSWORD -|- '...

You may also want to look at Microsoft Knowledge Base Article - 320125 "HOW TO: Move a Database Diagram"

Jeremy,

Check the updatedate field in the syslogins table. It is updated every time the password is updated. you could setup a job that does a datediff. If...

Onw more thing to add. If your user's have the ability to delete data, you may want to archive your full backups once a week (4 to 8 of...

Below is an example. You can make it faster by moving the alter table to an outer cursor and the column to an inner cursor, so the outer cursor...

Try looking at http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/reskit/sql2000/part11/c3961.asp

it is the SQL resource Kit which has a "Database Hammer". This may do what you are looking for.

October 3, 2003 at 10:54 am

#477020