GilaMonster (9/19/2008)

---

If SQL's running, the files can't be deleted as SQL will have...

Thanks so much for the advice.

webrunner

Pam Brisjar (9/15/2008)

---

These days I use Performance Dashboard and my own home-grown scripts for monitoring (they're free and portable). However, I've used Idera's Diagnostic Manager in the past with...

I knew I should have checked *.ldf - even though it is a log file, so I thought it was not a database file.

I guess both are considered "database...

No voting system is perfect, but it seems that electronic manipulation of votes is harder to track than manipulation of paper ballots. That's just my gut feeling, though. I may...

That was a cool, tricky question.

I got this in Query Analyzer (SQL 2000):

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near 'GO'.

Server: Msg 170, Level 15,...

What always gets me is that cheaters always know that they are not playing by the rules, so where is the self-satisfaction of a job well done supposed to come...

I'm interested in this too.

Is there any script that can log any "root cause" blocking SPIDs to a table so I can answer questions about whether or not there was...

GilaMonster (8/20/2008)

---

Actually, nothing's running the create proc.

When you get the sql text from sys.dm_exec_sql_text and the connection is running a stored procedure, exec_sql_text returns the create statement, rather than...

GilaMonster (7/30/2008)

---

I doubt it. Openrowset is a function to pull data into SQL in a table format. The default trace runs to disk.

I've never seen this on my servers...

Thanks...

I was saving to a table on my local test SQL Server instance on my desktop. (Where I was also storing the...

GilaMonster (7/29/2008)

---

Depends. Were you running it to file or to...

I'm starting to think the same thing. I found this page in a Google search:

http://jimmers.info/kb/VTables.txt

The file is titled "Undocumented virtual tables for Microsoft SQL Server 2000 SP3" and it has...

GilaMonster (7/29/2008)

---

It's not really possible to say where that comes from. It doesn't look like a system query, but that doesn't mean it isn't.

I would suggest you set up a...