Using Visual Studio 2005 Professional: We have two versions of SQL Server running: SQL Server 2000 Enterprise (Sql2000) is running on a Windows 2003 Active Directory Server and SQL Server 2005 Express is running on our local PCs.
I have an active/passive sql server 2000 cluster. Most of the time I remote-login into the server and use the enterprise manager to work. But now when I click on either of the node I get the following error: Encryption not supported on SQL Server ConnectionOpen ...
When we create new user objects, can we assume that the object_id will constantly increase? In other words, if I create a table and then a view, is it true that the object_id of the view if I query sysobjects view will be greater than the object_id of the table?
We have a .net application making ~100 logins and logouts with the same ClientProcessID. Is this normal? We are currently having a "connection pool" issue with this application. The app name on Profiler is showing as ".Net SqlClient Data Provider".