has the SQLServer user got the same privileges / access to the main database that the NT Authenication user has?

We've noticed similar issues with stored procedures and processing the returned data. One thing that we've found helpful is to use

SET NOCOUNT ON

as the...

I've just noticed the Ghost Cleanup process running against my production database; however, it was not running for very long. Reading this thread has helped me to not worry!...

Oh, that's good news -- I'm particularly interested in this as I'll be doing some log ship testing next week! Do you have a URL for that white paper?

Thanks!

...

We have a table that tracks the history of all our cases (about 210k). This table is currently 13.5 million rows, and growing at over 1% per day. ...

We too have this problem. If we rebooted the server every time the problem occurred, I think we would have to reboot every day!

I have considered a...

I have submitted it to the scripts section already.

quote:

---

Hope it gives you what you need to get your results and heres to a better week from now on.

---

Antares,

Thanks for that. Sorry I'm a bit late, but it's been a bad week...

Nice work, chaps, both this idea and the site generally.

It may be useful to have a flag so that people who are just making an announcement and are...

quote:

---

Looks like the problem is with my operating system. Mine is NT workstation. I think one should have NT server OS to...

quote:

---

I continuously see lists of 10 to even 20 skills "REQUIRED" for a position. In most of them, you see things like...