Another consideration is along the lines of security. If your DBA needs access to the server and you have them combined with the domain controller, you have a precarious...

skirr

You can do any of the following.

1. Add them individually

2. Have them added to a new AD Group, add that group to the server and then deny access.

3....

First verify the free space in the logfile. Then, if the logfile is largely made up of free space - you can shrink it. Use DBCC Shrinkfile.

Second, verify...

Thanks for posting that resource.

You're welcome.

Awesome question Ron. This information is extremely useful.

In this scenario you do not want to use sp_help_revlogin. That would recreate the the prod user with the prod password if the login did not exist on the...

Check these articles:

http://msdn.microsoft.com/en-us/library/ms174398(v=SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms189491(SQL.90).aspx

http://www.sqlservercentral.com/Forums/Topic541612-149-1.aspx

Put up a sign and say " DO NOT ENTER" and more than likely we will go in - inquiring minds. 😀

Steve Jones - Editor (4/15/2010)

---

Five bad jokes? That's it? I come back from a day of vacation to 5 bad jokes and a guy that should stick to using Excel...

Notice that the time stamp is different for each request. Each of these requests is a new request from the same connection. The CPU would be specific to...

Hmmm interesting.

http://www.dba-oracle.com/oracle_tips_intelligent_10g_DBA_maintenance.htm

Oracle provides maintenance tools to help do that, but they also say that you must do regular maintenance anyway.

Essentially the way it works is the management tools will do...

After you restore the database, you need to fix the orphaned users. The test server will have different SIDs than the prod database.

It is possible (Small Business Server does the same sort of thing), but I would never do it.

Why? Same reasons as already listed.