So, was the purpose of this article to make us feel holier than people who know less than we do, or inferior to those who know more?

> up to 100 instances

Yikes!

I would start with making a list of all the server names I had to process against (in a table, a temp table, or a cursor),...

Substitute this line of code after the "IF LEN (@Datefrom)...BEGIN":

Set @SQLString = @SQLString + ' AND crdate BETWEEN ' + CHAR (39) + CONVERT (VARCHAR, @DateFrom, 101) +...

I don't think there is any way, short of using dynamic T-SQL to recompile the procedure, to alter the number of parameters that a T-SQL procedure accepts.  However, you can...

Well, you might try setting up a domain user with permissions to run everything you need on all the servers, and set this domain user up as the owner of...

Security in computers is like gravity in physics.  In small amounts, it's easy, almost inconsequential.  In large amounts, it completely dominates everything around it.  It's one of the hardest things...

That sounds like an application issue, and I've probably helped as much as I can safely do so.  But that's never stopped me before.  You can either proceed to give the login...

It sends an email to Bill Gates, and waits for his permission to run faster!

Just kidding.  But it's amazing that an OS and a DBMS that together comprise a universe...

Sorry, Hammer, my fault.  I saw "Query Analyzer" in your first post, and that's all I saw.

Maybe you can try using the NT-shell "FOR" command with the "text parser" option.  I...

Yer right, Steve, she ain't much to look at.

Right now, though, I'm concerned that I just misread the whole requirement.  I assumed he wanted to know how to do that...

Hmmmm....  I may be venturing into uncharted territory, so be advised.

I assumed your login was a network login that owns the MSSQLSERVER and SQLSERVERAGENT services on your database server and could...

I know a way.  It ain't pretty.  ("Don't look, Ethel!!!!")

• Create a temp table with one long VARCHAR column.
• Create a @sql VARCHAR variable and set that string equal to...

Here's a Microsoft article on auditing:

http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx#EGAA

Otherwise, maybe there's a third-party app you could use.  This one looks intriguing:

http://www.sql-server-performance.com/entegra_spotlight.asp

Their blurb says, "Entegra allows an administrator to audit virtually any...

I'm not aware of any such thing as a SELECT trigger.  It seems to me as if you're best (only?) option is to wrap a layer of some sort around...

You're halfway there.  Running from the SQL server, you can execute 'xp_cmdshell' to spool off a job on the app server using the NT-shell "AT" command.  I have such a...