here's an example, but i don't think you can generate then column names dynamically this way(i know you will ask that!)..i think the AS 'Val' + RN will not work.

;with...

the answer is yes and no.

once I have a username and password, I'm good to connect with anything i can get my grubby fingers on...SSMS, a program i write, Access,Excel,...

great job on providing the data we need to test.

rows to columns and columns to rows is probably the single most asked question on the forum; i bet there are...

I don't think that will not work. Outlook.exe accepts no exposed command line arguments, so you could not automate it like that, i think.

what's wrong with opening a new email...

did you create linked servers to them yet?

once the link exists, it's nothing more than referencing them with a 4 part name:

SELECT * FROM LinkedServerA.databasename.dbo.TableA myAlias1

LEFT OUTER JOIN

LinkedServerB.otherdatabase.dbo.TableB myAlias2

ON myAlias1.Id...

http://aspadvice.com/blogs/rjdudley/archive/2005/05/13/2589.aspx

his first reason is my first guess...either the db...

ugg... i'm thinking that the same trigger in multiple databases will cause locking as soon as DB1 updates DB2 and fires the DB2 trigger, which in turn wants to update...

Toric what you want to do is to look in the scripts section here on SSC, and find some of the examples that script out roles and users, and their...

Jim is right, there is no hidden field anywhere that tracks WHEN an item was inserted or updated. if you don't have a column for it, you'll have to add...

thanks for the explanation!

yeah...you can use dynamic SQL in a trigger to do what you want, but if you have 50 databases, don't you need the same trigger on the...

well, before you go and do that, read this thread, where the original poster is having trouble because his procs don't work the same way anymore when TRY...CATCH is added.

Try...

wouldn't it fail anyway if your table doesn't exist in the database as you are going thru them with a cursor?

if you explain your process, we might be able to...

Oh man I hated that too;

it's not obvious, but under Scripting options, change "Include IF NOT EXISTS Clause" from true to false...then all your objects will script normally instead of...

you need to change it to refer to each database individually, and use a full three part naming convention to get to each database, I think:

INSERT INTO Production.dbo.AuditTable ....FROM INSERTED

INSERT...

dan don't forget a CTE is just a named sub select...you can move the CTE equivalent into the query as a sub query.

;with CTE AS (select other stuff...)

select stuff from...