Does this work with 2000? Me thinks not. The question should be devclared invalid as it did not make specific mention of 2005 and looking at the responses a...

There are two options here.

select distinct field1, field2

from table

or

select field1, field2

from table

group by field1, field2

Option 1 is the better for performance if you have a large table

I think you all have it right.  Acess must be removed.  But my reasoning is slightly different.  The biggest problem I have come across over the past 10 or more years...

Hi,

I've used the trial version of ERWin for the same thing.  A very nice tool to generate ER digrams on exisiting SQL Server database.

Mark

Ooops, forgot to remove the drop database part at the end of the statement.  Please don't forget to do it if you use the script.

Hi,

Here is the script I use to kill all users attached to a DB.

Declare    @DatabaseName varchar(50)

Set @DatabaseName = 'YOURDBNAME'

--Cursor for all the spids running against this database

    DECLARE SysProc CURSOR...

There are some great articles on this posted on the site.

http://www.sqlservercentral.com/articles/articleList.asp?categoryid=72

I'm in a similar boat as you.  I have decided not to get certified, but I am still going...

Hi,

Personally I like to use spaces so that other developers can see the code layed out in the manner that I selected.  Changing to spaces means all code will line...

Joyce,

We found on one of our servers (a dell Poweredge very similar to yours, dual Xeon and 2GB of RAM) that everything performed at its best when we restriced SQL...

Here's a script that we have used successfully for over 3 years to keill users and drop the database. After this step runs in the job we run a...

Void,

Could you please make the post. We are running about 6 installations of SQLServer and use 1 mailbox only for all emails from SQL. Our sysadmin team are...

Is SQL configured to use all of the server memory? If so drop it down so the OS can grab some, that worked really well here. We have...

Thanks David, worked a charm!!