Good idea for Vol. 3. I'll keep some stuff handy for that.

In the next article, I'll look at some of the ways in which we actually responded to disasters and...

Thanks for the complements and again, apologies. Even the best make mistakes and I know I'm pretty far from being there .

We try to...

Trace or constant sp_locks should do it. This was a problem in previous versions, but table creation and other ops were supposed to not lock tables in 2000. Are you...

Question corrected, points given back.

Apologies

In the properties for SQLAgent, on the Job System tab is a place you can specify the proxy account. Setup an account that can connect to SQL Server and run...

SELECT @Table_Name = '''' + MIN(Table_Name) + '''' FROM DB_Table_Names

Copy osql.exe to their machine.

It will grow alot!

Not sure how to estimate this. Are you updating one field or many? At the least, it will have the...

By default, if someone has quest access to msdb, they can create a package. It basically requires insert to sysdtspackages in msdb.

Glad you figured it out and it's working.

Thanks for the followup.

I believe profiler is lossy, so if performance of the server becomes an issue, it will drop events.

If the server is overloaded, you might get this a lot. I'd reduce...

Using the with move is only in restoring the database. You wouldn't use this with the log.

when restoring the log, the database must have been restored with the "norecovery" or...

I agree with lots of what Andy wrote, but I'll chime in as well.

SQLInjection will become one of our biggest worries going forward. With so many bugs and patches coming...

Thanks for the link catch. It's fixed.

You can use either with the IIS server connecting to the SQL Server. Not sure about the actual end user, but I suppose if they connect to IIS using Windows...