Ganesh

Not sure how well this would perform, but one way of doing it would be to create a temp table with an identity column, say tempID.  Create an index on...

I think the DENSE_RANK function is what you're looking for.

John

Backup

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm

Restore

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/877ecd57-3f2e-4237-890a-08f16e944ef1.htm

Andrew

This is tedious if you've pasted a lot of lines in, but it works.  At the end of each line, delete the carriage return and then hold down Shift and...

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...