Viewing 15 posts - 7,216 through 7,230 (of 13,469 total)
change your raiserror to a print statement...wouldn't raising an error of 16 or above inside the trigger rollback the trigger?
July 6, 2011 at 8:40 am
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...
July 6, 2011 at 8:38 am
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...
July 6, 2011 at 8:30 am
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...
July 6, 2011 at 7:42 am
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...
July 6, 2011 at 5:52 am
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...
July 5, 2011 at 2:19 pm
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...
July 5, 2011 at 1:05 pm
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...
July 5, 2011 at 11:57 am
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...
July 5, 2011 at 9:58 am
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...
July 5, 2011 at 9:15 am
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...
July 5, 2011 at 8:49 am
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...
July 5, 2011 at 6:17 am
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...
July 2, 2011 at 11:32 am
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...
July 1, 2011 at 2:57 pm
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:
July 1, 2011 at 2:47 pm
Viewing 15 posts - 7,216 through 7,230 (of 13,469 total)