change your raiserror to a print statement...wouldn't raising an error of 16 or above inside the trigger rollback the trigger?

i'm with Gail; all you can do is trace it...so i don't think so; for example the DMV's that have the execution plans for a given statement would occur after...

here's a recursive CTE example i keep in my snippets; if you can provide the CREATE TABLE/INSERT INTO statemetns like this example, we could help you with yours, but this...

run as a batch, i saw what you pasted was missing an open parenthesis, but otherwise just fine.

i suspect it's a highlight-and-F5 issue.

are you highlighting, say each section one part...

Vertigo44 (7/6/2011)

Sorry I should have been more clear.

I have already imported a cobal database into a sql database using an ODBC connection.

Now that I have finished mapping the fields...

this has got some nice comparison tools on the page..i selected Datacenter and Enterprise for example, and then i can scroll through so many comparision options ....

http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

at a glance, it...

i think all you need is EXEC in from of the proc: multi line statements require EXECUTE procname, only when a command is standalone can you just put the name...

depending on the application, if it was doing anything with importing from access,excel or raw text files using the JET 4.0 driver , jumping to 64 bit becomes a big...

SSMS is not the ideal tool to display varchar(max) fields, as GSquared was implying:

one of the settings it uses for increasing perforamnce can also prevent the full text of a...

an update statement with a WHERE follows the WHERE restrictions, so if you are getting more rows affected than you expect, the best thing to do is look at...

i've used SQLBulkCopy for moving data from other sources to SQL, and i like it a lot...it is really fast.

i suspect the SELECT * stuff you are seeing is probably...

OK Babu, say you've presented a list of views in your GUI, and the end user selected one of them.

i don't think you need any other parsing DLL at...

yeah it was a little work to find;

all this work is from a Win7/64 bit OS.

my example assumes you installed SQL Server 2008; although i installed 64 bit, the specific...

if you are not hosting it yourself, you just have to trust that the DBA is a professional, and does not to want to steal your data

there's another thread running...

too many windows open!

i editit it off in another window, and then when i thought it was ready, hit the "reply" on the wrong tab...

I'm properly admonished now, thanks!

:w00t: