Jeff,

Is it so that you are carrying out lot of processing in the tempdb database. I have seen this happen with us also. On analysing, i found that tempdb was...

Try Changing the owner of the database to probably your login id or any other login id and then change to sa. Hope this helps.

With reference to what sam said, if you don't limit the memory for SQL Server after enabling AWE, SQL Server will take all the memory leaving just 128 MB for...

Thanks numbers.

That works fine.

Can someone help me with this.

What i believe is the owner might have been deleted from syslogins table due to some reason. On adding another user, we add him to...

Sorry for confusing everbody.I believe If the dbo is orphaned, it does create this problem. drop the exisiting user and grant him dbo priveleges and it helps.

Antares/Steve

I'm having the same problem.When i checked the code of sp_helpdb, the error is generated from the following SQL.

select name, suser_sname(sid), convert(nvarchar(11), crdate),

dbid, cmptlevel from master.dbo.sysdatabases

If i execute the above...

The below KB article explains how to implement cdonts/cdosys for mail.

http://support.microsoft.com/view/tn.asp?kb=312839

I haven't used this tool but hope it helps.

http://www.sysinternals.com/ntw2k/freeware/pmon.shtml

Can you let me know what email id i can send it to?

Simon,

Let me know if you would like to view the two different execution plans. It would be difficult to post as they are big but let me know whatever is...

Alternately, you can also query sysprocesses table and it will give you the blocking resource. Enterprise Manager is a good tool but you have to refresh on your...

Here is the code for the procedure:

The view view1 which is used joins 8 tables.

Again, i didn't write this procedure and i definetely agree that it can be improved.

CREATE PROCEDURE...

If you have IIS and SQL Server installed on separate servers, you won't be able to use CDONTS from with SQL Server. CDONTS requires a local SMTP server. You might...

Simon,

I agree with you. That's the first thing which came to my mind when i saw the query and the query is not one of the best queries and it...