If you have text in red (which means it is a quoted string) that looks like T-SQL code, the stored procedures are probably using dynamic SQL.  This means they are...

Apparently you could set up a trace table in SQL Server 7.0 using xp_trace_addnewqueue, but not in SQL 2000 with sp_trace_create.  I don't know how Profiler does it.  Maybe you...

I've never tried this, but a quick search on MSDN for "SQL Server 2000 login auditing" turned up a lot of links, including this article that discusses enabling C2 auditing...

It's obvious you're too young to have been using computers in the pre-Windows era on Flintstone-style Teletypes.  Lucky you.

You can use the ECHO command in a bat file to display...

Using FULL JOIN will include rows where the join field is NULL, but they will be in different records.  Assuming tables A and B are joined on field XYZ and...

Another good condition for the WHERE clause would be "and hostname <> @@servername" to be extra careful not to kill a server process or scheduled job.

This assumes users can't just...

Look at the program_name field in the results of sp_who2.  You will see "SQL Query Analyzer", "SQL Query Analyzer - Object Browser", "MS SQLEM", and/or "Microsoft SQL Server Management Studio"...

There has to be a login available for the application to connect to the server, and it has to have access to a database, before it can use an application...

If you want to run something too big for the command line, save it in a script file and use -i {inputfile} instead of -q {query}.

As an alternative to -i...

You can script the stored procedures to a file, then back that up.

Right-click on a database in Enterprise Manager or Management Studio and look for "Generate Scripts...".  Use the formatting...

I may have heard of it on talk radio, or on the internet, about two years ago.  The people behind it started working on it about 20 years ago, and have done...

Your entire paycheck is part of a company's cost of doing business, but the FICA matching contribution is part of their labor budget so the easiest thing to do might...

I was able to reproduce this behavior in Enterprise Manager, but not with Query Analyzer's Object Browser or in SQL 2005 Management Studio.  I am guessing that the SQL-DMO code...

You are correct, sqlmaint uses DBCC DBREINDEX.

I believe it was DBCC REINDEX up to version 7.0, then renamed DBREINDEX in SQL 2000.  In SQL 2005 it's ALTER INDEX (although DBCC...

In addition to the argument over where business logic belongs, there is the issue of security.

Data can be secured easily if all access is through views and stored procedures (i.e....