Also note that the system procs aren't actually in the user databases, though they appear to be. They're in the hidden resource database.

Everyone else covered the how, so I'll cover they why.

Be aware that by doing this you are breaking the log chain and preventing yourself from being able to do restores...

Ouch. I always use VPCs for this kinda thing. Reinstalling takes far too long.

Got katmai running in a VPC on my laptop. Runs supprisingly well, though I haven't tried to...

Easiest thing is just search and replace before you save the script

It's not so much that the syntax has changed, but that SQL is now permitted to ignore the Top 100% ... order by construct where it appears anywhere other than...

You can't modify the system objects.

You're probably best off writing your own query against the catalog views sys.columns, sys.types, sys.tables...

Select * from sys.databases where database_id > 4

The syztem dbs have IDs from 1 to 4, the user databases from 5 up. (The system resource db is an exception, but...

You can get the latest CTP on the Connect site (https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395)

It is beta software, so be careful where you install it.

It's a .net object that acts as a link between the connection and a data set. The adaptor gets told what the select, update, insert and delete

statements for the...

Which is fine if you don't need to know who taught which student. If you do, you'll have to...

The event captures queries completing within procedures.

Start profiler, connect to a server (I would suggest for a good workload, use the production server. If you use anything else, you...

Do your reals have decimal places?

If not, just query based on the range that the smaller data types can handle

Select * from Array_table where value between 0 and 127 --...

Lazy perhaps. Seeking the quick and easy path.

Ooohhhhhh........ :hehe:

Try running profiler and capturing the SP:StmtCompleted event (under stored procedures). That will fire an event for each query in the stored proc. You're best off running profiler for a...