2008 Dev Edition $50ish.

Free time...priceless :laugh:

medelstein (3/11/2010)

---

I tried creating the runninSqlStatements stored procedure and it gives me a syntax error on this line:

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) as qt

with this error:

Msg 102, Level 15, State...

Try dbid on sys.sysprocesses - that's not a DMV/DMF but I can't remember the funky new equivalent for the moment...

Good point Jeff. My approach though, is to always try to provide code if I have time. My thinking is that although my script might be copy-and-pasted, anyone...

Database context only makes sense for a currently-executing...

Second question first:

Dynamic Management Views and Functions (Transact-SQL)

Just noticed this is the 2005 forum. So, here's a 2005-compatible version of my code:

DECLARE @Sample

TABLE (

account ...

I will check, you know...;-) 😛 :w00t:

Sigh. And here is the corrected version of the sample-data-generation script.

This one doesn't try to set identity_insert for a table with no identity column, and also has the decided...

Maybe:

DECLARE @Sample

TABLE ...

SARGable maybe...but definitely undocumented and unsupported.

Even...

Also:

BULK INSERT (Transact-SQL)

OPENROWSET(BULK...)

You should not rely on it. Use the dynamic management views instead, for example:

sys.dm_exec_connections

sys.dm_exec_sessions

Paul

To illustrate Rob's point:

DECLARE @Sample

TABLE (

raw_data INTEGER NOT NULL,

...

2000000

2E6

2 * POWER(10,6)