We are Devo

Alvin Ramard (11/12/2009)

Jack Corbett (11/12/2009)

Alvin Ramard (11/12/2009)

Lynn Pettis (11/12/2009)

Alvin Ramard (11/12/2009)

AVG is not interchangeable with SUM. Was that written on the day the coffee pot ran dry?

AVG*COUNT might...

Guilty!

(I have...

You can't use trigger-based audits for text, image or other blob data types in SQL 2000.

What you'll have to do is do the auditing from the update commands, whether those...

Yes, you can do that. You'll have problems with it if any of the parameters are for output values, but it does work for input parameters.

Because of the issues...

Use a command-line control to zip it. WinZip has a command-line interface, and I'm sure other compression programs do too. Set up a batch file or issue the...

You can't declare a variable with the same name as a parameter.

I just tested this:

create proc ParamTest

(@Param1 int)

as

declare @Param1 int;

select @Param1 = 5;

select @Param1;

Got this:

Msg 134, Level 15, State 1,...

Now that's funny!

I'm having visions of the ability to talk about SQL being the primary requisite for the job.

You're welcome.

Not that it actually matters, but SSCertifiable is a title based on number of posts and points. The username is right above that ("GSquared"). Just like with your...

How does the variable @dbname get assigned a value? Is it an input parameter?

If so, I'd do something like add this before executing the command:

if exists (select * from...

Change this:

SET @sql = 'SELECT TOP(1) login_date FROM ' + @dbname + '.dbo.User_Session ORDER BY login_date'

INSERT INTO DBA..unused_Db_Log

VALUES (@dbname, @sql)

To:

SET @sql = 'SELECT TOP(1) ''' + @dbname + ''', login_date...

Are you building the connection dynamically inside the OpenRowset command? Or are you dynamically building an OpenRowset command? I really can't tell what you're doing from the little...

The ":CONNECT" command is for SQLCMD.exe. If you use it in Management Studio, there's an option for "Use SQLCMD mode". What it does is connect to a server,...

What I meant was, why not make those columns the clustered index,...