The easiest way is the advice above using the sp_ms procedures. These aren't supported, but they will likely be continued since some MS procs use them.

It was created at the request of a member for discussions about employers and issues working for them.

The original thread is here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=325486

It's on the list. We'll get it done.

I've been told I generalize too much, though some of it is in fun. I've also faced many developers who have a basic knowledge of SQL and avoid using or...

send it to me (sjones@) and I'll upload it. Not sure where the bug in this one is and it's stumped me.

I was wondering who would dig into the circular reference, and of course it would be a highly esteemed architect!

Joking on the reference,...

OK, OK, apologies. That was the weirdest thing. The process we use to load the articles is generating an old one on disk for some reason. Did it again this...

Some very interesting comments and thanks for all of them.

I think anecdotal experience is nice, but with most employees, some are good, some not so good. I'd like to think...

You probably need to read more about how SQL Server works. There is always a log file with your database and you need to back it up or truncate it.

A...

Is there a particular place where they are hanging? Can you add some debug code?

It sounds like something in the communication channel is getting lost. Any data access updates to...

I think MyLittleAdmin can help you if you want administrative SQL stuff. If you are looking for something else, what are you trying to do?

http://www.mylittletools.net/scripts/en/home/

I've usually run things like this through osql and then captured the error output in a file with the error switch.

I'm not completely sure, but they're likely background processes that SQL uses. Does it matter? Or are you having some problem? I have a number on my system and they're...

Or use Truncate instead of delete.

Loren,

Great questions and I have no idea. We haven't gotten into the "review" process and I haven't heard of any censorship of the forums. AFAIK, I'm the only one administering...