So will the sequence always be a value of 1, 2 or 3? You have to have something to control your pivot with.

1) have you forced a reindex since removing 50 million rows.

2) Have you tried updating the statistics via either of the previous mentions?

Also, does the table have a clustered index...

Most common

create proc sp_getconsultantability @consultantid numeric(9) @module nvarchar(50)

as

if exists ( select consultantability from dbo.consultant where consultantid = consultantid AND module = @module )

BEGIN

 select consultantability

 from dbo.consultant

 where consultantid = consultantid

 AND module =...

It depends on your version of SQL.

For instance in SQL 2000 if it is only one row always one answer is SET @ID = SCOPE_IDENTITY()

No those are items of the MMC snap-in itself and cannot be removed.

Look at "Current Activity" in SQL Eneterprise Manager and see what else is going on in the database.

Sorry, Brian. I suggested he do it. I should have been more clear and say wait a couple of days to see if anyone else posts to the original.

Unfortunately I am not a good source. Personally I would say go with a Global Group (which shouldn't cause you any overhead or open any unwanted security) and avoid the...

I'll let you know if I find anything else. But I have seen this before and it is a pain I know. Will pose to some friends at work tomorrow.

It says the connection is not open, this can be a permission issue an yes I have seen strange errors. When I was asking the account SQL Agent is running...

Sorry I do see the difference. But the answer woul be th same as the link I gave. I hav don several installs of Oracle and hav run into issues...

Sorry don't remember the number transalation for this. There is a ComponentChecker hidden somewhere off the link I gave you that would be able to tell.

Please do not cross-post. I have made a response here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=272865

Again I woul run sp_updatestats to see if it causes any impact. However with that said have you tried looking at the estimated execuion plan to see if anything jumps...

Take a look at

http://technet2.microsoft.com/WindowsServer/en/Library/79d93e46-ecab-4165-8001-7adc3c9f804e1033.mspx

I haven't admined any Domains in a while so my knowledge is very rusty. But I believe you have to identify the SQL Server as a...