Use parameters in your client side code as well. Don't

Myvar.Execute "myproc " & myparam

Use the proper parameter client side methods (add to the call as methods, not concatenations) when calling...

Service accounts are administrator level functions, usually, so I, or another admin, changes the password if it's needed. So we never store them for that reason.

I also never share them....

Actually that's a great question and probably worth an article or two. If Jeff/anyone else if up for it, send me a draft. I'm sure people are intereseted. Likewise Mr/Ms...

You DO NOT want to grow on demand. You want to set a size that will be used over the next 3-6 months, as Tom mentioned. Do it during periods...

How are you adding to the DB? I don't see any place in there where you need to shut down the db file. You should be inserting into the database...

Unless the log is directly after the backup, you can't.

The way this works is (over time):

full backup 1

- log 1

- log 2

full backup 2

- log 3

- log 4

If you have...

How are the copies made as well?

sp_help_revlogin, script out logins, add them back.

Might need to script roles out on the server level, not sure where that's kept in 2005 and how easy it is to pull...

What's stable enough?

Haven't seen any news about issues with it. I know that SS2K might not be supported on W2K8, they tend to support only 2 versions backwards (the Windows...

This wasn't database mirrroring was it? I believe replication and mirroring, while similar, function differently.

Truncate not being tracked in DDL triggers is a problem. I hope this is fixed in...

I think Jack has the only good way to do this in 2000.

sp_changeobjectowner

you would not update system tables.

The DTS package will run under the credentials of SQL Agent as a job. You need to be sure that this account has rights to the database.

I think you might...

http://msdn.microsoft.com/en-us/library/ms188783.aspx

CREATE INDEX has a row and page level locking option. Someone created the index with it set to OFF.

Tools | Options | Results | SQL SErver | Results to Grid, there's a checkbox for results in a separate tab.