I use a case just like Lutz suggested; only difference is depending on what the data is capturing, I have a cut off date, so i don't accept dates...

there is a suite of views that you can search the "definition" column from,

for example this might get you started:

select *

from sys.all_sql_modules

where definition like '%myTableName%'

you can use this view...

its variable scope;

anything like variables or temp tables created during the execution of a stored procedure do not exist outside of the proc...that's why you can call the same proc...

there are prettier ways to do this, but does this give you some ideas?

DELETE FROM MyTable

WHERE orderid IN(SELECT orderID From Table1 WHERE orderID IS NOT...

this works with the example data you posted; dunno about the data types, but the code works:

==edit i built this based on the first psuedocode, you posted again prior to...

alex the logic is in your cursor; if you are doing something to one row, you can do the same thing to multiple rows; somewhere int here you've got what...

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