check your join criteria as well... any chance something could be invalid, like JOIN Table2 T2 t1.ID = t1.ID (when it should be t1.id = t2.id?)

since this is express, can you find the link to SSMS and right click...run as administrator? does that get you in so you can disable the trigger?

Logon failed for login [server name/instance] due to trigger execution.

that says right there that A logon trigger has been put on the server and it is specifically rolling back your...

ahh i see it:

you need EXEC in there: can just have the proc name.,

...unused]) EXECUTE '+ @db_name+'..sp_spaceused ...

what you pasted was missing a lot...the table1 definition, three variables and more.

i think your insert needs to be inside the @sql variable.

SET @sql = ' insert into [master].[dbo].[Table_MetaData]([name],[rows],[reserved],[data],[index_sze],[unused]) '+...

ok, to do that, i think you'll just want to wrap a grouping query , and join that to the original table...

it might look scary, but it's one way...

just break it down into it's peices:

SELECT

NEWID(),--returns a varchar-ish something like D93D157E-3749-4A26-8410-859B237CE7FF

CHECKSUM(NEWID()), --returns a bigint like 1339413509 or -1323543251

ABS(CHECKSUM(NEWID())), --makes sure it's positive like 1585842432

RAND(CHECKSUM(NEWID())) --returns a value between...

you could try using the built in Schema Changes Report in SSMS;

instead of a specific database, right click ont he server itself and browse to schema changes history

look for the...

i know logically, it makes sense to get the id's you are looking for in one table, adn then do a seperate step;

but from a good TSQL point of view,...

nope no practical limit; that table could be billions of rows in the subquery;

the only practical limit might be speed; proper indexing might need to be looked at so...

yet another way is since you already did the export, using a decent text editor like EditPlus you can use a regular expression to find \n (CrLf) and replace it...

i stand corrected; unless the call was wrapped in a transaction, the code does execute, the row gets deleted, and the archive table does get the deleted row even with...

toddasd (7/6/2011)

---

The RAISERROR doesn't rollback the transaction, you would need an explicit ROLLBACK TRANSACTION after that statement.

Wendel, your trigger is fine, but I'm thinking other triggers may be interferring. Disable...

Learning a lot today guys, thanks for the input.

I did as Phil suggested,and changed my datasource to use an OLEDB Source, made the SQL do the conversions, and it exports...

GilaMonster (7/6/2011)

---

You don't. You tell whoever wrote the app that they must call stored procs not run adhoc queries.

Frankly the idea of modifying the returned data is terrifying. If I...