rew i think you are right...when you grant someone ALTER, the can alter or drop the object...as they might need to drop in order to create/recreate

i've got a database DDL...

my mind reading hat is better than yours today...

actually he put in a description along with the subject, which you can only read at the topic listing level, and cannot...

doh! rereading, i can see that;

this should help:

http://support.microsoft.com/kb/321185

2005 versions:

For example, the results resemble the following. Collapse this tableExpand this table9.00.1399.06 RTM Enterprise Edition

The following table lists the Sqlservr.exe version...

not sure what you mean...SP=Stored Procedures, right? Stored procedures are not 32...

i have this code in my snippets for stripping HTML tags, but there's other ways to do this, regualr expressions and CLR being boatloads faster, as GSquared stated.

this might not...

it looks like the data consistently has comma-space-twoCharState in it. you'd have to verify your source.

It's my experience that MLS data is available already parsed into fields, I guess this...

rew can you login as that specific user in SSMS, and run these two queries? maybe the user has other roles or rights?

select * from fn_my_permissions(null,'SERVER')

select * from fn_my_permissions(null,'DATABASE')

take a look at the view sys.schemas;

this seems to give me the lsit I think you were looking for; note you have to run this on each database:

select * from...

i wouldn't give them the db-owner role, but instead create a role something like the following:

remember the role of db_owner has the ability to drop the database, which you probably...

the why is easy...by design, when you use the GUI to change a table, it drops the table and recreates it. Not always, but since it is so easy to...

that would occur if any space existed in the last name, before the slash.

a name like Mac Bride/Bob Lee would make that happen... you'll need to tweak it based...

it takes a bit of manipulating, but you need to use substrings and charindex to find the slash, and grab the left and right parts of it; you have to...

the Export Wizard gives you the option of copying tables or using a query in like the sixth step: much easier using the wizard than SSIS.

you have to select your...

remember a foreign key can be created only on a column with a primary key or unique constriant; on it, an integer column that happens to have an FK doesn't...

i'm just guessing at your interface, but do you have some UI that has a link per SQL statement and they click one link to get the results, vs...