from a security presentation standpoint, I'd think that seeing 22 rows one for each security module, and having usually 4 security points, but sometimes 7 or 8 points would be...

ok i see what you mean now;

i think the solution is to simply sp_helptext sp_helpuser, copy the parts of the code you DO want to use, and use THAT in...

Joe Celko (7/14/2010)

---

SQL is not a text language. Get a copy of Mellisa Data or other address data scrubbing tools. They will get you to CASS and 9-1-1 Standards much...

i can't duplicate the issue;

i can certainly insert the EXEC SP_HELPUSER into a table, but what do you mean by a database alias?

do you mean where you rename...

well...you're going to present someone with a grid with 700 + columns? why? I would simply NOT do that.

maybe a redesign should be called upon to revisit why the data...

Julie try this function agaisnt your data.

this strips out everything that is not a number and not a character...so spaces, control characters, brackets or whatever get stripped out;

that seems to...

failrly straightforward requirement Bosco. they will not get any rights you don't give them. if they connect with SSMS, you cannot hide the existence of other databases, but they can't...

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...