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...

Ashok

Where will the data you are hoping to insert come from? If you show us what you've tried so far, that should help us to see exactly what you're...

Nisha

The information you're looking for is in the sys.sql_modules system view.

John

I believe there's a utility called sqlping, but anyhow, if you search for "ping" in Books Online, you'll probably find what you're looking for.

John

Now is the time to go to Books Online and read carefully how sp_executesql works. When variables are involved, it's not as simple as supplying just the query string...