RE: Block Users from using sql server query analyzer

SSC Guru

Points: 323504

July 12, 2010 at 12:16 pm

#1191633

this is a per-SQL-Server installation/instance trigger, not a per-machine trigger...

so if you have a server named "PROD", and it has a default SQL instance, and two named instances, ie "PROD\SQL2005" and "PROD\SQLEXPRESS"

you would need to create the logon trigger 3 times, to cover every sql instance on that one machine...once connected to PROD, the second time to PROD\SQL2005, and finally PROD\SQLEXPRESS.

does that help flesh out it's scope of a logon trigger for you?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!