I did use this method once in my security model to give users rights to read data through stored procedures and be able to create new users, reset password ,...

djj provided a link to 'execute as' I would still strongly suggest that you familiarise yourself with the link I...

There should be some more info in the SQL error log, I would asume something similar to this:

Msg 3201, Level 16, State 1, Line 1

Cannot open backup device 'G:\SQLBackup\MyDatabase_Backup.bak'. Operating...

Thats one option.

The other one is to use a signed stored procedure. This is definetly more secure and...

parmsivan.kannan (12/3/2014)

---

Hi Guys..

Is there any queries to get a data from server A to server B?

For Eg Am working in Server B but I need to take...

Regardless to it being...

Hi Gila,

Thanks for quick reply... I should have made a copy of the error log, didn't think about that under pressure to fix the machine, now it's too late as...

In SIMPLE recovery model, SQL Server still logs all transactions, but will minimally log certain bulk operations; in effect, the level of logging is the same as that applied in...

Question that is very often asked on interviews 🙂

Thanks!

Actually this script WILL work on sql server 2008 because THROW...

Good one for Friday,

THANKS!

Hi Quira,

please refere to the stairway to SQLCLR 1. i think it answers your question

http://www.sqlservercentral.com/articles/SQLCLR/104406/[/url]

Hi rot, i know this is a silly question, but are...