I want to run the following query :: SELECT S.* FROM sys.dm_exec_requests S JOIN sys.dm_exec_sessions R ON r.session_id = s.blocking_session_id It works when i run it in SQL Server Console. ...
I have SQL 2008 server installed on the local machine with the instance name "SQL2008". I'm trying to connect to it using Management Studio. I can connect with the sa authentication but am unable to ...
I'm having a strange issue where I try to attach to SQL Server 2008 running on a second computer (both machines running Win7 64-bit), either through the Data Sources in Visual Studio or via the SQL ...
Setup: SQL 2008 Standard SP1 64Bit on Windows 2008 - one CPU, 8GB of memory The server is dedicated to SQL Server. The server memory settings were as default (min 0 max 2000GB) Connections from 8 ...
In my home network, I have three machines - trying to do a lab for mirroring on SQL 2008. > Machine A can connect to B and C. > > Machine B can connect to A and C. > Machine C cannot ...