The article is great, but I've read that the SPN needs to be re-registered when SQL is stopped and re-started.

I usually provide the service account read-write SPN privileges on AD....

Thank you

Based on all the material out there, is this option enabled for all databases by default once the Perform Volume Maintenance Task privileges are assigned to the service account...

However, this would be based on the assumption that the hardware and the OS platform will support SQL 2000 after another decade.

We revoke the execute on xp_regread as well for public. Now we have some users who are unable to register the server in SSMS and are getting the same errors.

How...

I enabled Named pipes and changed the port and it now works.

Is it a requirement for SQL Server 2005 cluster that named pipes needs to be enabled?

The crux of the problem seems is the "WITH EXECUTE AS CALLER" statement. There are several procedures with the same t-sql having the same issue.

Anyone seen this problem before. This...

i added 'dom\group' and tried executing

IF NOT EXISTS (SELECT name FROM sys.server_principals WHERE name = 'dom\group')

PRINT '1'

PRINT '2'

and as expected it Prints '2'

CREATE PROC sp_test

AS

IF NOT EXISTS (SELECT name FROM...

I changed the compatibility level (master database) to 90 but still the same issue. It won't add the new user to the sysusers table in the master database while creating...

did this ever get resolved? I'm getting the same error and need to know how to resolve this.

I tried it with SQL 2000 compatibility and it gave me the same results it did with the SQL 2005 compatibility so it is using threading

I did change the MAX DOP to test this and it gave the same results as SQL 2000. I reverted that back to the default.

Thanks for the quick response. This...

I agree with that...but would anyone be able to explain why this would happen...

I tried this as well and everything turned out fine...

i have verified the permissions on the share (both share and ntfs permissions) and it looks ok. Moreover, the agent service account is local admin on the box.

Has anyone experienced corrupted DTS packages?

We ran some file mon tools and it seems like the job can read the file but not import the data. Does file import using DTS...