I can't offer useful advice without knowing what the error was and on what command it was raised...

What do you mean by 'needful'?

They're not a deprecated feature, they're essential for the optimal performance of the query engine.

Check Books...

In the Generate Scripts wizard, on the options page, change the server version for the script to SQL 2000.

In the first script you posted, you're missing the \ on the drive letter. You have D:BackUpYourBaackUpFile.bak instead of D:\BackUpYourBaackUpFile.bak The error message indicates that that's a problem with the...

Excellent!

What precisely do you mean by 'doesn't work'? What part doesn't work, what error does it throw or what does it do that it shouldn't be doing?

Since you're on SQL 2005, use sys.indexes rather than the old sysindexes. sys.indexes contains only indexes, sysindexes can contain the column statistics as well.

Please don't start multiple threads for the same problem.

Asked and answered: http://www.sqlservercentral.com/Forums/Topic757156-145-1.aspx

I can't see any reason why that would be deadlocking then. Can you post the exec plan of one of those inserts? (saved as a .sqlplan file, zipped and attached)

Triggers fire when some data in the table is changed. If you need something that runs at a certain time of the day, you need a SQL Agent job.

Ankur Bajaj (7/21/2009)

---

supposing u get to support a transitioned server where u find that there are hundreds of users who have permission to backup log etc...will u go about identifying...

Never played it, but I would like to try it sometime.

Switching back and forward between the...

Why can't you go and speak to them, explain why what they're doing is harmful (lay down the recovery consequences) and ask them to stop. That would be my first...

Lots. Dungeons and Dragons may be the best known, but it's far from the only one. Many of the World of Darkness...

However the transaction log cannot be truncated (by a log backup or checkpoint) while a full backup is running.