Although if you move to SQL Server 2008 (or R2), you can use Change Data Capture to perform this type of change tracking without using triggers.

That's not a normal issue, but evidently it's happened before[/url]. It sounds like you must have some third party software involved with your backups, possibly interfering in the backup process...

yessen (6/28/2010)

---

Grant Fritchey (6/28/2010)

---

There a number[/url] of articles[/url] right here on SSC that can help you out. You just need to use the Search window over there in the upper...

I'd check out Craig Mullins book Database Administration. It's not so much a "how-to" manual but a "what kind of job are you looking for" manual. It's pretty technology agnostic...

Volume like this in sQL Server will require both hardware and careful database design, appropriate tsql, good indexes, proper maintenance... I'm with everyone else. You're probably better off hiring someone...

Yep, it ought to work just fine with 2005.

You should also check out Professional SQl Server 2008 Internals and Troubleshooting.

Not knowing the events you've defined,...

balasach82 (6/28/2010)

---

Thanks....Thanks....Thanks.

Thats a great way of explaining. Now I understand. Its complicated to get the query's count(which query ran how many times).

Still having one doubt.. that fileds with NULL values.....

The text data field shows the full query, including parameters passed. Take these two calls as an example:

EXEC spMyProc @parm1 = 42, @parm2 = 'Optional Parameter'

EXEC spMyProc @parm1 = 42

Now,...

Not to mention that the out of the box security settings are pretty tight:

Script exec is prohibited by default

ps1 is not associated with the shell

must provide a path to a...

There a number[/url] of articles[/url] right here on SSC that can help you out. You just need to use the Search window over there in the upper right to track...

Jeff Moden (6/27/2010)

---

Lynn Pettis (6/27/2010)

---

I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has...

GabyYYZ (6/25/2010)

---

Lynn Pettis (6/25/2010)

---

Steve Jones - Editor (6/25/2010)

---

PASS. No interest in flying 64 hours to ski for a couple days.

Send me pix, I'm happy to wait for Oct here. I...

Sounds basically accurate to me. The only addition I would make is to be careful about the shrink process. It can lead to other issues, including file fragmentation. If you...

It doesn't sound like the log file has been broke, just improperly configured and managed.

Whether or not 5gb is the correct size really depends on the number and size of...