you only need to grant EXECUTE on a stored procedure.

by design, if the user has EXECUTE permissions, whatever the proc does, whether INSERT/UPDATE/DELETE, the proc will run successfully, and the...

a full backup is always an exact copy at a certain point of time...so it's just not possible that a backup restores some, but not all users. a backup is...

can't you just have your process change each database to RESTRICTED_USER WITH ROLLBACK IMMEDIATE

OR

SINGLE_USER WITH ROLLBACK IMMEDIATE

to kick them out, do your work or maintenance, and then put...

Pam just to be sure the path tot eh file is correct, does this work for you?

i think it works, but does it do what you were looking for?

--get...

server wide, it's only the last 100 meg of...

DROP TABLE counts as a DDL function,and would be in the default trace, if it didn't get rolled over:

fastest way is the built in reports in SSMS:

Laura I was feeling a little inspired when i fiddled with...

i thought TIFF was an image format, so it's not really pages...

if you had a 10 pages in that single image, do you want an image that is 8.5 inches...

here's my two cents.

a linked server is just a connection to a licensed server.

no different from whether i connect via an application i create, or from a developer...

Gail will weigh in I'm sure, as she's had a lot more experience on this, but I'm very sure that unrepairable error. = restore from backup, as it cannot be...

oops wrong post sorry.

well Laura i threw some time at this, as it...

• This reply was modified 7 years, 1 months ago by Lowell.
• This reply was modified 6 years, 7 months ago by Lowell. Reason: reformatted due to new web design for code tags

Laura this is a tough one;

SQL doesn't have granularity you are looking for;

it's pretty much grant ALTER on the schema, and that applies to all the DDL for all objects,...

my examples of that would depeend on how much memory you had for plans to stay cached in memory, i think;

SELECT

fn.*,

st.*

FROM ...

it depends on WHICH DMV also;

sys.dm_exec_connections are only valid while the spid is connected, i think;

sys.dm_db_index_usage_stats is good until a stop start,

but i think sys.dm_exec_query_plan would get cleared...