what you are asking for in your first post here is a number of complex things on some very wide subjects, much too wide to provide any meaningful examples without...

dynamic data ?

did you try either of the solutions we gave you?

both work for an unlimited number of items...it's just string concatination.

if that's not it, explain in detail what you...

skcadavre (7/14/2010)

---

Lowell (7/14/2010)

---

turning the related rows into a comma delimited list is what you are after right?

the easiest way is to use a neat trick using FOR XML.

here's a nice...

turning the related rows into a comma delimited list is what you are after right?

the easiest way is to use a neat trick using FOR XML.

here's a nice example I...

here's a really nice example of using PIVOT that i picked up from a post here.

if you were able to provide the two table definitions and some sample data, we...

sticking with an actual RESTORE command is the best solution i think. you need to time things correctly, because you need to coordinate the following steps:

1. a scheduled...

it's a security thing....see this post for a long winded explanation with screenshots and a solution:

http://www.sqlservercentral.com/Forums/Topic951702-146-1.aspx

That is the gotcha!

xp_cmdshell will not use your login credentials. nope. not a chance.

you expect it to use it, but...

xp_cmdShell doesn't use your personal credentials. it uses the account SQL starts with instead, and in your case that account doesn't have access to the network path:

this is a common...

profiler = heavy impact i agree, but a server side trace I still believe has negligible/almost nil impact; that was what i was trying to say.

i've placed both a DML...

you need to decide that the new user is going to copy/inherit the roles of a specific user.

for example:

insert into user_role

select

3, --the userid of the new person...

winston I'm in the same camp of not worrying about the trace impact after this article about the near-zero impact of a server side trace where someone actually compared...

ahh... no i don't believe so...the database is not available, or no definitive to the to the logon connection...you know i can connect to master, but query db1 using 3...

this is a per-SQL-Server installation/instance trigger, not a per-machine trigger...

so if you have a server named "PROD", and it has a default SQL instance, and two named instances, ie "PROD\SQL2005"...

i'm thinking something like this:

bring everything is as one big field...i'm assuming varchar(8000) would hold it, but it might need varchar(max).

once in a table, use CHARINDEX2 to chop everything up...