You could use a computed column, and put a unique index on that.

Populate the computed column with a CASE statement that sets it to either the email address, or the...

Is the application using a different isolation level than you are using via Query Analyser e.g. READ UNCOMMITTED as opposed to READ COMMITTED? This is normal in any development environment,...

Is the application using a different isolation level than you are using via Query Analyser e.g. READ UNCOMMITTED as opposed to READ COMMITTED?

I would be concerned!

Your transaction log contains all the changes done to your database and should be backed up regularly (e.g. if you can only afford to lose 1 hours...

I lost interest after I saw the bit about not being able to back out SP4 (you need to uninstall and reinstall SQL), and the complexities of upgrading all the...

I wouldn't even contemplate it without testing it first. Even a fairly small upgrade to Windows components should be tested first.

I've seen too many innocuous looking upgrades cause problems...

select db_name() - this gets you the name of the current database context

select @@servername - this gets you the name of the server

What version of SQL Server are you using?

You need Enterprise Edition or Developer Edition to go above 2gb

Try:-

Master.dbo.xp_cmdshell 'BCP "select * from pubs..AUTHORS" QUERYOUT G:\BCPTEST2.TXT -C RAW -c  -T  -S Server'

Try sp_changeobjectowner

The BCP out from the table will be to the OS filesystem, so you won't see any errors in the SQL Server error log about full databases.

Have you run out...

I'm not sure about Windows Server 2003, but in Windows 2000, the 3gb switch actually tells the OS to reserve 1gb for itself, and leave 3gb for the apps.

If...

How do you know it is only accessing 5gb?

With AWE, you can only see the actual amount used via the permon counter 'Total Server Memory', not task manager.

What does your...

Have alook at this post:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=220567

All of the other suggestions are sound ideas, but shouldn't be affected by a stats update.

SQL Profiler will be your friend here. Look for queries with an abnormally high number of...