Are you saying you think SP2 has broken it, or that you think it might be fixed by SP2?  I couldn't find SQL Server Agent mentioned in the SP2 bug fix...

Andrew

Your first reference should always be Books Online.  You get a much quicker answer than you do here!

DROP INDEX 'tablename.indexname'

John

Could be a number of things.  How often do you update your statistics and/or reindex your tables?  Use DBCC SHOWCONTIG to find out how fragmented your indexes are.

John

Ed

Thanks for this.  I've tried everything now - it doesn't work either under the local system account, or my own domain account, which is a local admin.  There's nothing in...

Chad

I'm afraid I don't understand what you mean.  Please will you provide DDL for your table(s) and some sample data, and somebody should be able to help you.

Thanks

John

Mark

I suppose that, if Red Gate agrees with you, they won't give him his free software.  But if they don't agree, then fair play to him - even if it...

Ed

Thanks.  How do I grant Read access to the event log service?  I'm still baffled, because I've changed the service to run under my own domain login (which is a...

Mark

I think the word "demanding" is too strong - how about "enquiring about"?  But I agree - it isn't an award for demanding privileges.  You have to put in the...

"Quit looking for socialist handouts."

Mark

Actually, a "socialist" handout would be based on need.  The kind of handout that Dinakar is seeking is more a product of a capitalist society, where...

Thanks for your help, everybody.  I must admit that I didn't realise that the Agent XPs are automatically disabled when SQL Server Agent stops.  So they were a bit of...

Yes, that is the way we do it.  You can't restore any databases unless SQL Server is running, which is why you either need a copy of the data files...

Set up all your servers as linked servers on a master server.  Then loop through each server with a query that inserts all logins with a null password into a...

We copy out our data and log files for master, msdb and model to somewhere safe.  That way, we can use them to start SQL Server quickly after a file...

Robert

UserID is an integer, so why are you using the FLOOR function on it anyway?

John

Please start a new thread.  Follow the link below, then choose the most appropriate forum and click on New thread.

http://www.sqlservercentral.com/forums/default.aspx

John