ahh, i see it now;

objectname is fine for objects, like tables/procs(anything that exists in sys.objects), but you need a different field in the xml data for the database name

CREATE TRIGGER...

you had most of it, it looks like, but you forgot to handle the EVENTDATA() function, which ahs the currently scoped event information

CREATE TRIGGER Prevent_DB_Drop

ON ALL SERVER

FOR DROP_DATABASE

AS...

if it's a single 8 gig table, BCP is going to be a better option.

you'll need to create the table DDL on the Target server(as a new name) Like TableName_Imported...

i did get it working on my own;

If you've installed the 64 bit drivers, and also set these two properties on the drivers:

--Required settings for the provider to work correctly...

on line 7 there's a space inside "Purchasing _v_Line_Item_e" between "Purchasing" and "_v_Line_Item_e", resulting a double alias.

if the tablename has a space, it needs to be bracketed: [Purchasing _v_Line_Item_e]

otherwise...

drew how about using patindex to find the first [0-9] match?

this gets us kinda close, i think, except for that "10 SERIES BP MIS MONITOR"

select

patindex('%[0-9]%',drugname )...

we can probably help, but not without providing some DDL and sample data that represents the structure and data we need to look at;

if you can convert "customerID, transactionid, transactiontime,...

do you mean how do you get teh newly created PK values for data you inserted? especially so you can then do a subsequent insert into a child table?

the answer...

yep that's exactly correct. you end up doing a GRANT INSERT ON dbo.ServerLogonHistory TO public in the AuditDb; that way your trigger does not run into permissions issues when...

the absolute best way is via a programming language.

you'd need to first establish some sort of relationship to the data...that is, you know that C:\AutoCad\drawing_424.tif

is related to a specific record...

you'll run into permissions problems accessing, say 10 databases in a single query;

the calling user would need at least read permissions in every single database for the specific table(s) involved..

i...

collation differences can be a...

can you change this:

EXEC(@finalquery)

to this, and paste the results after running the procedure?

PRINT @finalquery

EXEC(@finalquery)

also, is there any reason you are rrunning it twice in the same proc?

EXEC(@finalquery)

EXEC sp_executesql @finalquery

wak_no1 (6/26/2013)

---

Thanks.

If I run the SP unaltered, it outputs a neat looking script, is there no way I can simply backup the output, without having to amend the SP and...

also, this looks incorrect to me, there's commas, double commas but no values:

'AND (@Part_Type_MP = ,, OR (CHARINDEX(, + CAST(P.Part_Type as VARCHAR(50)) + ,, @Part_Type_MP) >0))'

is it the single quotes...