Silly question (maybe):

Have you tried the export from the server itself? Another workstation with SSMS installed?

You have a bunch already. Go to the Character Map and explore the WingDings (and other) fonts.

Start > All Prog > Accessories > Character Map

create two different datasets. 🙂

You're close. The parameters (when multiple are chosen) are passed to your procedure as a comma delimited list. You will need to split those out into a table of values...

Why not just "try it" Set up a task to delete any *.* files and set it to run in 5 minutes, then see if it fails. :w00t:

Yes, you can update those tables, but they are "fussy".

Check out this article, it shows how to work around it. I'm fairly certain it works in 2008.

http://www.sqlservercentral.com/articles/Development/2824/

According...

And THANKS a ton Gail! This got us on the right track at least. 🙂

Eugene Elutin (11/2/2012)

---

Try this:

DECLARE @sql VARCHAR(8000) = 'SELECT * FROM FROM sys.objects'

SET @sql = 'SET NOEXEC ON;

' + @sql + '

SET NOEXEC OFF;'

BEGIN TRY

...

That might be it.

So how would I (or is it possible) to do this inside a procedure and capture the output.

In other words, I...

Jeff Moden (11/1/2012)

---

Jason Selburg (11/1/2012)

---

Good idea dwain, but I do not want to/ can not execute the statements.

I need only to check the syntax.

Also, the syntax can be...

Good idea dwain, but I do not want to/ can not execute the statements.

I need only to check the syntax.

Also, the syntax can be any valid sql. So...

Ha Ha...I need to sloooooow down. I totally missed the two FROM's

Lowell (11/1/2012)

---

I've played with this a couple of times, Jason; i've used it to chop a SQL statement into elements, so i could play with building my own formatter, and...

Lee Crain (11/1/2012)

---

So, the Optimizer will ignore all existing query plans in the cache and possibly implement a new one because it will be aware that a new index has...