add the logins to the dev db.

the users will be there once you restore

sp_change_users_login will synch them.

The DBA should be setting standards, naming, format for procedurs, comments, etc. See what they have and if they don't have something, start getting one in place. It's an easy...

It also stops the lookup for syspermissions and the recompilation. In general, if you run this on your personal server or any server not loaded, there is no difference. The...

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...