Showing posts with label mssql. Show all posts
Showing posts with label mssql. Show all posts

Saturday, February 25, 2012

No. of connections available for Per Seat License

We have a MSSQL with per seat license of 20. The MSSQL is sitting in the same machine as the asp.net. Does that mean that the the no. of connections and Max Pool Size are limited up to 20 only?
Thanks,Ben
I don't know that any of us here are going to be willing to venture a guess on the often confusing legalities of SQL Server licensing. I can recommend this link as a starting point for your research:SQL Server 2000 Pricing and Licensing. Be sure to look at theSQL2KLic.doc in the upper righthand corner.

Monday, February 20, 2012

no syslogins table in master

i was just reading that logins for mssql are stored in master-->syslogins. i don't have a syslogins table--but there is a sysxlogins.
is this a problem? any ideas why the name has an 'x'?
thanks!In SQL Server 2000 : sysxlogins is system table but syslogins is only a view ...|||thank you thank you

Originally posted by snail
In SQL Server 2000 : sysxlogins is system table but syslogins is only a view ...