lots and lots of script contributions here on the site:

http://www.sqlservercentral.com/search/?q=script+roles

also search fro "script permissions", lots of nice examples of that as well.

the OP asked in a PM how I had done my stored proc i referenced; I'm posting it here to add fuel to the fire; others might have some ideas...

I've created a stored procedure featuring EXECUTE AS that allows an end user to Create a Database, which then adds roles to that database, and finally adds the calling user...

opc.three (5/25/2011)

---

Just eyeballing your code so forgive me if this is a rabbit hole but I think if client_net_address is NULL then you end up with something that will anger...

huh?

maybe a copy/paste error?

EVERY statement you posted is making the Question1 field equal to a count of the persons name?

it looks like the sub query gets a total, and has...

ok, following up here, i created a server trigger, and a user with the same name as the OP for testing.

I'm gathering info based on this snippet to get the...

the columns in the table and the columns in the BULK insert must match exactly, with no extra or missing columns....unless you use a format file.

you can use OPENROWSET to...

Jeff Moden (5/24/2011)

---

Gosh, folks. I've not tried to import the data (yet) but the "Read Me" pointed out in the original posts seems to identify column requirements quite nicely....

what a pain that file is.

this is what i did:

i converted all teh damn unix LF to vbCrLf.

then i used this script...i had to tweak it a few times,...

indenting code is your best friend.

while there's no hard and fast rules, i tend to do something like this:

columns indented compared to the select

joins are indented from the FROM...

could it be users from the domain that are not explicitly added as logins? so if the domain group myDomain\Dev was added, people get in with no login?

so you'd have...

pretty sure it has to do with the import package defaulting to a 50 char field, and the data for example, on line 1284 is 54 characters in length.

"Beautiful Zion...

not sure it's possible...you need the backup to complete before you can determine it's size....

That makes me think it cannot be done before the backup is complete...unless it's based on...

ekta your example only works if an index has one and only one column in it's definition...otherwise it scripts two definitions...

also note there are different types of bar codes, so you need to know which style you need: