Any errors in the SQL Server log? Also, what happens when you try telnet servername 1433 from the Win7 machine? It should allow the connection and give you...

Also check that you're using an account that is db_owner on the linked server db. There's a known issue when querying across linked servers and statistics permissions. Post the...

Try something like this

SELECT employee.EMPLOYEEID, employee.FIRSTNAME, employee.LASTNAME, employee.STARTDATE, employee.EMAILADDRESS, org.ORGANIZATIONID, job.JOBTITLEID

FROM dbo.AUEMPLOYEEJOBTITLE as job

CROSS APPLY

(SELECT TOP 1 emp.employeeid, emp.FIRSTNAME, emp.LASTNAME, emp.STARTDATE, emp.EMAILADDRESS, emp.ENDDATE

FROM...

You're best bet is using sp_whoisactive v11.11 by Adam Machanic.

http://sqlblog.com/blogs/adam_machanic/archive/tags/who+is+active/default.aspx

That will give you a quick view of the resources in use by each SPID

They are not the same but you can get the same result.

Intersect does all columns, inner join only the specified cols.http://blog.sqlauthority.com/2008/08/03/sql-server-2005-difference-between-intersect-and-inner-join-intersect-vs-inner-join/

There's an example demonstration database called AdventureWorks2008 that sounds exactly like what you want to achieve in the long run.

http://msftdbprodsamples.codeplex.com/releases/view/55330

There's a tutorial on importing the data into mappoint to display...

Seemed to work fine for me. Have you run the following command to attach?

CREATE DATABASE AdventureWorks2012 ON (FILENAME = 'D:\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf') FOR ATTACH_REBUILD_LOG;

http://forums.asp.net/t/1758542.aspx/1

From the URL:

VS 2008 only supports ReportViewer 2008, which only supports up to RDL 2005 Schema. The namespaces being declared in the reports you listed are using RDL 2008 and...

I'm interested to know what the issue was. I've had a similar issue with a bad SAN firmware.

SELECT DISTINCT product_id

FROM fact_sales

WHERE (agent_id=1 AND product_code in (1))

OR (agent_id=2 AND product_code in (3))

OR (agent_id=3 AND product_code in (2))

OR (agent_id=4 AND product_code in (1))

AND & OR operators

http://www.w3schools.com/sql/sql_and_or.asp

Do not use the ALLOW_DATALOSS option unless it's your absolute last resort.

Do you have any backups that can be restored?

What error messages are in the SQL error log...

For clarity, OPC.three is referring to .NET CommandTimeOut property for the client accessing SQL server. http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx

SQL server itself has no default timeout for queries running directly from a client, but...

That's going to be an ASP problem, not a TSQL problem. The dropdown must be sending a 1 when generating the TSQL insert statement.

You need to modify...

Do you know how long each database backup is taking? Has the time increased for a single backup or all of them?

Apart from the slowdown issue, with 3.5TB of...

You need to give permission to the Agent Job owner to use the Proxy.

EXEC msdb.dbo.sp_grant_login_to_proxy @proxy_name=N'domain\user', @login_name=N'domain\user'

GO

Or browse to Principals under the proxy in SQL Agent.