auto_fix (From BOL):

Links a user entry in the sysusers table in the current database to a login of the same name in sysxlogins. You should check the result from the...

sp_change_users_login basically handles the oprhaned users (depending on what options you use). There is a script on this site that loops through all users in the database and runs sp_change_users_login...

Check out sp_change_users_login in Books Online. If your server login name is the same as the database user, you should be able to get their IDs to match up using sp_change_users_login.

I don't know exactly what criteria you are looking for, but you could try using select DISTINCT iOwnerid, if you are just making sure that there is at least one...

Without knowing anything specific about your cluster setup, I would suspect that you have a configuration problem with the cluster. The cluster groups should be set up with all of...

I don't know if you are intested in books, but SQL for SQL Server (Murach) is a great intro to T-SQL. I really like their format (normal textbook stuff on the...

Look into VMWare (server virtualization). A company that I previously worked for had a lot of success consolidating their servers (including SQL Server) using this product. It is especially nice...

Could you be a little more specific about what you mean by a 'split cluster?'

If it is an Active/Passive cluster, that would mean that there is only one active SQL...

There's a lot of good information and links in this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=122690

Try using something like between. Here's something that may help:

Declare @dt1 datetime, @dt2 datetime

Set @dt1 = '2003-10-24'

Set @dt2 = dateadd(day,1, @dt1)

then use something like:

AND DCCntHst.SentDate...

I don't know enough VB6 to help you out with specifics, but I know that the Hitchhiker's Guide to SQL Server 2000 Reporting Services book includes examples for deploying and...