Alvin Ramard (5/13/2010)

---

Steve Jones - Editor (5/13/2010)

---

I did leave out the pool. I was thinking that your feet were in the blue, plastic, 6" wading pool sitting in front of...

steve block (5/13/2010)

---

I was looking at a server side trace to replace an interactive trace that I run from Profiler. I don't see an option to Save to a...

70 pages is a fair bit. My entire Master's dissertation will probably only be around 70-80 pages.

What interests you in databases, within the areas that the lecturer set? I ask,...

I'll see if I can repo it.

tony.turner (5/13/2010)

---

As I understand the section in...

There's no audit table by default.

You'll need a server-side trace if you want this in SQL 2000 as well as 2005/2008.

Connect time I think. There's either a bug in the docs or in the code.

How long is a piece of string?

Seriously, there's no way, just from the size of the DB, to make any educated guess as to the time to shrink. Depends on...

Why?

I've had a look at the counts on our main prod server and there are 28 (all returning 2 rows) out of...

Nope. System tables cannot be updated.

Script,...

That's not SQL Server code. A very quick google search reveals that PostgreSQL supports that function.

Multiple statements within a procedure? Query stats works that way, I'll admit I've never used procedure_stats.

Check one of the procedures that has multiple rows, see how many queries it has...

Ok, so the DB is attached but suspect. Please run the following.

ALTER DATABASE <database name> SET EMERGENCY

Once you've done that, you should be able to access the DB, though it...

Full table definitions (the create table statement) and index definitions please (all indexes). See the article that Dave listed.

I asked about the upgrade message. Is the SQL instance that you're trying to recover this with IDENTICAL to the version that this DB was attached to before the SAN...