good question.

leosinclair (9/7/2012)

---

I'm having issues deploying my Reports in Visual Studio 2008. I can open the Report Manager on the web browser but I cannot deploy the Report. My URL: http://MySeverName/Reports_DSIM01/

I...

if SAN was restarted.

Can you offline-online those disk resources?

For Ad hoc queries you can query catalog table:

;WITH XMLNAMESPACES (

DEFAULT 'http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition',

'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner' AS rd

)

SELECT name

, x.value('CommandType[1]', 'VARCHAR(50)') AS CommandType

, x.value('CommandText[1]','VARCHAR(50)') AS CommandText

, x.value('DataSourceName[1]','VARCHAR(50)') AS DataSource

FROM (

SELECT name

, CAST(CAST(content AS VARBINARY(MAX))...

try by Virtual Name of the cluster.

You have to connect via SSMS to Virtual IP or Name of the cluster in order to view replication monitor.

Yes you can.

1. Run the Create Publication wizard on the publisher. Make sure NOT to create a snapshot.

2. Once the wizard has finished, right-click the new publication, choose Properties

...

na1774 (8/7/2012)

---

Hi All,

We have a table 'Servers' which lists all the Servers in our Company.

My scenario is that we have a a Dynamic as well as static FQDN to connect...

Did you try Update Lock.

SQLHammer (8/6/2012)

---

Hello,

I recently performed a server migration and I'm left with some SQL Agent issues. I restored an msdb from one server to another, I ran sp_help_revlogin on the original...

"If it ain't broke, don't fix it"

oops did not read the other post

What's on D, F and T drives?

disable sql server vss writer service.

Markus (8/1/2012)

---

I have a default instance on a WIn2008R2\SQL2008R2 cluster and I want to save and use an Integration Services package from a data import as a job. I...

MyDoggieJessie (7/31/2012)

---

Unfortunately EVERYTHING is trying to connect to this server...

I opened two command windows, started the service in one and immediately alt-tabbed over to connect in the other (both windows...

You don't need a cursor in catch. Primary key, ERROR_NUMBER, ERROR_LINE and ERROR_MESSAGE should be enough.

Try this:

DECLARE @MyTable AS TABLE (id INT NOT NULL PRIMARY KEY CLUSTERED, name VARCHAR(10) NULL)

BEGIN...