Please watch your forums. This was in the SQL 2000, General area. It has been moved.

I don't think this is possible. You can filter by table, which could help if you know the tables with triggers, but I don't think this is possible.

What are you...

If this is homework or an interview question, please solve it yourself.

Also, you should post your own attempt when asking others.

Do you mean the filename?

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31640/

Be careful with this and monitor it carefully. The backup process doesn't tolerate any delays well and will fail if the network hiccups. You'd really be better off buying more...

Most things are on the list. It's a question of priorities and resources, both of which are limited right now. Some changes coming tomorrow (fingers crossed) and then we'll look...

On the post screen where you type, there are sections below the "Post, Spell ChecK, Preview" buttons. One is called "Post Options". I believe it's closed by default, but if...

I'll have to check out that movie, but it definitely is the small stuff that kills you.

Often because you don't really want to estimate it. The small things that you...

At my last "real" job with JD Edwards, our on call was paged out by the help desk (24x7). If they didn't get a call back in 15 minutes, they...

Or "H" is better at getting stuff done than the rest of us 😛

Close, but don't use recovery with the last log. This will catch you at some point.

full backup with no recovery option

diff backup with no recovery option

translog1 backup with no recover...

You can set a startup procedure to execute when service starts.

http://msdn2.microsoft.com/en-us/library/ms191129.aspx

Don't do this. Spawning processes in a trigger is an extremely bad idea.

Use Service Broker as mentioned in this thread. http://www.sqlservercentral.com/Forums/Topic403678-361-2.aspx

I'm trying to get someone to write a nice basic...

Yeah, my formatting doesn't work well.

I'll try to edit this down. Waiting on a new built to get me motivated 🙂

Low priority. I think the counters are cached for visits and don't appear until you come back, so it's previous visits 🙁