I think SSCommitted hit the nail on thehead.  Life is not a piece of paper saying you know "stuff" butcan you...

Using Books On Line simply enter @@ in the "Look for:" line. You are just missing it. No big thing..

I have been evaluating FogLight from Dell for the past month and am very impressed with it. You might look into it.

You might find what you need by looking into the following roles:

SQLAgentUserRole

SQLAgentReaderRole

SQLAgentOperatorRole

...

Upgrades are not as bad as some would try to make you think. The key is doing your home work.

First I would use the UpGrade Advisor:

There are any number of solutions to this issue. Search for "comma delimited strings" in SQLServerCentral and you will get plenty of examples of functions that will do just...

If you are looking for a title then you might not want to become a DBA at all. I have been a DBA for 15 years and would not...

Well it looks like this thread is going down a different path. To clean up your database you have a few options.

1. Create a new database and...

The content is sound and fairly well thought out. As stated by others the code is a mess with errors, typos, etc. I do not like the ideal...

Check this link: http://msdn2.microsoft.com/en-us/library/aa337272.aspx

One simple way is to build SP simular to the code below in which you would pass the desired db name and call that proc when needed.  There are other...

The error is subtle to spot but it will cause you problems every time.  The best way to trouble shoot these types of problems is to print the statement rather...

I would think that you should have () around each complete select statement. 

The following code will work also and perhaps give you a different way of looking at things.  The first part of the query just builds and populates  the test table. ...

A windows group can not own a database.  See sp_changedbowner in BOL.   A possible work around would be to add the desired group to the DB as a user then...