Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2012-05-08 : 16:52:24
|
| I CREATED A LOGIN TO HAVE READ ONLY PERMISSION, i WANT TO limit this login to have only 2 connections to the database from the same concurrent server.ServerA = 2 connectionsServerB = 2 connections |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2012-05-08 : 17:40:40
|
| sql server 2008r2 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-08 : 17:45:03
|
| You'll need to use a logon trigger for that. You can modify the example listed here:http://msdn.microsoft.com/en-us/library/bb326598.aspx |
|
|
|
|
|
|
2 connections