Just to clarify, there are two stored procs being referred to here:

sp_cycle_agent_errorlog - cycles the SQLAgent error log

sp_cycle_errorlog - cycles the SQL Server database engine error log.

Both of these stored...

Richard Fryar made an excellent point there. Remember that SANs are a cost-saving resource designed to optimise storage usage, not performance. In reality, using a SAN can be a like...

I don't unfortunately Chris. However, from memory, I think it's replacing the name of the primary key with its objectid. Quite why MS did this I don't know.

Jon.

Thanks Kamran, useful article for those of us familiar with RS2000, good to know some of what RS2005 has to offer.

Especially like the intellisense and date picker features, nice...

Totally agree. To me a good manager is one who has the confidence to let the people he's managing get on with their jobs. He should protect them from the...

Just an aside on the SQL-DMO solution - probably the easiest to code, but from personal experience it can be a pain to package up into an application, and can...

...and he was playing Galaga in the coffee shop - great game

I would have to nominate Equilibrium (http://www.imdb.com/title/tt0238380/) as my favourite along with The Matrix.  If you loved the lobby scene in The Matrix, you'll like this. Same mindset, great film,...

You shouldn't have any problems James, backups have been able to restore automatically since at least SS2K5 beta 2. Microsoft tend to get features like that working and stable first - no...

Personally, having had a lot of experience of third party database product vendors, I'd request them to write it. If it's their system, running on top of their database design, then...

Eduardo,

Chris' recommendation is an excellent one. The Hitchhiker's Guide... is an *exceptionally good book*, with a very good accompanying DVD showing you how to set up various tricky parts of Reporting Services - and...

16k?

Six-teen-kay ?

When I were a lad we had to make do with an Acorn Atom and half a kb of memory.

AND we managed to cram Space Invaders and an...

Agreed. Production DBAs are a very valuable asset who bring much needed experience to the job, and are needed in a professional organisation of any size. Development DBAs rarely cut it...

What a great feature !  Well done Microsoft and thanks Vinod for showing us how to do this 🙂

Kolya,

I don't know specifically, but will try to find out. Should be able to post some info. soon with regard to whether the DBCC command set is the same for...