Granting Execute Access to All Stored Procedures to a Given User
A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.
2005-12-13
9,938 reads
A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.
2005-12-13
9,938 reads
Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.
2005-11-14
8,206 reads
Day Four wrapped up SQL Pass 2005. As a first time attendee to this event, my head was swimming by...
2005-10-01
1,348 reads
Day Three of PASS had a decidedly better start than did the previous day. After finally figuring out the effective...
2005-09-29
1,293 reads
This year, I have the opportunity to attend the SQL PASS event in Grapevine, Texas. This is my first PASS...
2005-09-28
1,404 reads
Day Two at PASS started out on a sour note. Rewind about 36 hours, to when I was checking in...
2005-09-28
1,535 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers