Use the HAVING clause so that you only return results with sum = 0. Then join that result set to the original table to get the rows that...

sp_helptext should give you what you're looking for. But you may have to grant your user higher permissions than it already has - check out the Permissions section of...

Helin

It's not something I've done before. But one thing you could try is to monitor the sys.dm_exec_requests view and check that cpu_time and/or logical_reads are increasing all the time...

Just because you can put it all on one drive, it doesn't mean you should. For optimum performance, you should put data and log files on physically separate disks....

Nita

There's plenty of information on database snapshots in Books Online. Have a read through that, and post again if anything doesn't make sense to you.

John

Another thing to look out for is that INFORMATION_SCHEMA.COLUMNS also lists columns in views. Therefore, if @TableName happens to be the name of a view, it'll also fail because...

And beware of the following:

(1) The way you have designed this, you need to give the user permission to create tables.

(2) You don't have a check for whether the column...

SELECT CAST(MyString AS INTEGER)

John

Just divide by 100.0.

John

Jeff Moden (4/15/2008)

---

More correctly stated, I'm "Planning on Planning"... Although my plane ticket certainly wouldn't cost as much as your's, I have to plan the time (time off is $Lost),...

Look up DBCC FREEPROCCACHE, DBCC DROPCLEANBUFFERS and sp_recompile in Books Online. I recommend that you read all the related ("See Also") topics as well. Please post again if...

It's not really clear what you're trying to do. If you want to open a SQL script file (with a .sql extension), use SQL Server Management Studio.

John

Not if you have foreign key constraints....

But be careful: this will only give you the first 4000 characters of the procedure definition.

John

Nisha

I can, but I won't. Look up sys.sql_modules in Books Online, then try to write the query yourself. If you're stuck on anything particular then post back and...