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

What makes you think those rights are not being taken over?  Can the user still connect to the database?  How are you trying to connect?

John

It sounds as if your instance of SQL Server isn't properly clustered.  However, without more specific information, it's difficult to help you.  What error messages are you getting?  Is this...