Don't worry about tables in tempdb, when you closed the application, the connection closed and sql server got rid of the temporary data on it's own.

If you have any doubt...

If you are concerned about space you should also limit the maximum size of tempdb files (right click tempdb -> Properties -> Files -> autogrowth column -> Set maximum size...

Check your PATH variable, another version of bcp.exe is probably in it (or even the bcp from sybase).

Check if the account running the sql server service has enough rights to look at the registery value.

Tara-1044200 (9/20/2010)

---

I think you got me wrong, user already has permissions to INSERT and UPDATE but i want the user to execute the stored proc by which the user will...

That means he got a grant select on all tables (or that public has been granted select) or he has a select trough a view.

You'll have to look for it...

You can check which roles have db_datareader assigned to them (or Select) and see if the user is in one of these role.

You can use the tables sys.database_permissions and sys.database_principals...

You won't be able to connect using DAC if your sysadmin account are either locked out or removed, if you still have a nt user as sysadmin, just connect using...

I guess you meant a varbinary(max) column?

As far as i know you can't do it in TSQL only, you would need to use a tool or an application to read...

Every error message in the error log has an error number that is the same in all language, you can use it to translate the message and you'll just have...

Can you give more info about why it's not working?

With execute as you should be able to do what you want while just granting execute on the procedure you created.

This should cover most of the rights (to be used inside EXECUTE AS xxx) SELECT b.name, a.name, c.*

FROM sys.objects a

Join sys.schemas b on b.schema_id = a.schema_id

CROSS APPLY fn_my_permissions (b.name +...

SQL Server want to write data at a specific place (because of an index), but if there is not...

You have to try ... catch each block separately:begin try

print 1

end try

begin catch

print ERROR_MESSAGE()

end catch

begin try

raiserror('fake error',16,1)

end try

begin catch

print ERROR_MESSAGE()

end catch

begin try

print 2

end try

begin catch

print ERROR_MESSAGE()

end catch

Output:

1

fake error

2

In other word, it depend on the procedures...

If you only need snapshot...