Can you use the built in C2 Audit Functionality from SQL Server 2K?

that audits literally everything that happens, every end user activity(ie every sql command), as well as a lot...

THE VARIABLE GOES OUT OF SCOPE WITH THE BATCH OPERATOR:

DECLARE @@MYVAR VARCHAR (50)

SET @@MYVAR='KEWL'

PRINT @@MYVAR

GO

PRINT @@MYVAR

gives the following results:

KEWL

Server: Msg 137, Level 15, State 2, Line 1

Must declare the variable...

Paul i was assuming he would use a loop to go thru all databases...and assumed that some of the databases were not related to his app.

rather than letting the cursor...

you want to delete items where all the items are null, so use that logic instead of NOT IN and OR statements:

create procedure pr_cleanup

as

begin

  if exists(select name from sysobjects where...

i think you would have to set up a profile to track logins; it's not stored anywhere, it is just an event that happens, unless you profile to a table.

I...

why not install /upgrade to SQL 2000 and set the database compatibility to 7 instead of the default of 8?

then all statements are executed against the sql 7 rules such as...

the standard and enterprise versions can only be installed on the server OS platforms...win2k Server/ advanced server or win2003.

on 2000/xp editions, it automatically installs personal edition instead.

personal edition, in order...

I would do it as a separate operation using the UPDATETEXT function;

here's an example that might give you some insight, but go for the BOL to get otehr examples.

Create Table...

Enterprise Manager will exhibit this behavior(seemingly stalled or not responsive)  if the db's on the server are closed, and there are a lot of databases; EM must open each database,...

well, the syntax for sp_addlinkedserver is here or in BOL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp

EXEC    sp_addlinkedserver    @server='S1_instance1', @srvproduct='',          ...

remember a datetime is actually stored as a decimal type number, and the format is arbitrary....its stored as a number like 12345.67, where the 12345 is whole days, and the...

go ahead and download the service pack from this page;

 http://www.microsoft.com/sql/downloads/2000/sp4.mspx

note in the middle of the article it explicitly says that it is for the MSDE, and that you need...

if you are going to be connecting dynamically, i think it is better to use an application to determine and connect to the server, and then execute whatever code you...

could it be the file system operations of the FTP and UNZIP operations are not truely completed when it goes to the next step of the TSQL? The OS may...

select CONVERT ( datetime,getdate(),102 ) might do what you want:

2005-05-27 11:55:35.467