You would need to make sure logon_trigger_login can SELECT from the table:

USE GK50LIVE;

GO

CREATE USER [logon_trigger_login] FROM LOGIN [logon_trigger_login] WITH DEFAULT_SCHEMA = [dbo];

GO

GRANT SELECT ON dbo.LimitedLogins TO logon_trigger_login;

GO

Then you could modify...

Are you sure you were encountering deadlocks? and not just significant blocking?

Deleting large swaths of job history can wreak havoc on your server if you have a lot of jobs...

A Trace (accessible via Profiler or server-side trace) can be thought of as a logging mechanism for SQL Server. Using SQL Trace

Since you're on SQL Server 2008 you could also...

In an adjacency list a child typically has one parent. I think in the OPs model a child can have multiple parents, in which case the permutations when traversing the...

You're welcome! Thanks for posting back, confirming that it worked!

32-bit or 64-bit?

How does selecting data from an Excel Workbook fit into your overall process, i.e. what are you trying to accomplish?

Microsoft® SQL Server® 2008 R2 Best Practices Analyzer is a good place to start.

Monitoring Best Practices by Using Policy-Based Management has a bunch of useful checks as well. PBM is...

SQL Kiwi (5/1/2012)

---

I would also strongly discourage the use of the OLE Automation procedures (especially with a cursor as in the demo code). Service Broker may also not be...

Dev (5/1/2012)

---

I agree with opc.three and would recommend to create a table for logins that you are going to restrict (or any other custom operation in future) for user. Small...

pamozer (4/30/2012)

---

In my ssis package how do I change the database that the procedure is running on in the for each container. I have an Execute SQL Task that...

How to: Uninstall an Existing Instance of SQL Server (Setup)

You could keep a list of logins hardcoded in the trigger as the example shows, or as I said you would need to keep them in a separate table. Having...

capn.hector is correct too (we were typing at the same time so didn't see his post)...I do not expect issue with an in-place upgrade, but a fresh slate is always...

Sapen (4/30/2012)

---

Thanks for your reply. Right now SQL Server max memory setting is set to 25600MB and I want to change it to 29000 as I have ensured that there...

NaCl (4/30/2012)

---

from Microsoft's 2008 R2 Security Best Practices Whitepaper:

•Have distinct owners for databases; not all databases should be owned by sa

i understand the advantage of ownership by an account that...