With that query you created a stored procedure. To execute it and see the results just issue:

EXEC sp_whoisactive

If you want to export a whole result set to Excel, the easiest way I know of is a small ad free Management Studio add-in called ssmsboost. It can export...

Don't use activity monitor, it falls short in many areas.

I suggest that you use Adam Machanic's sp_WhoIsActive.

Which flavour of replication? Merge? Transactional? Snapshot? P2P?

Also, if Merge or Transactional, is subscriber updateable (two-way or one-way replication)?

andrew gothard (12/10/2014)

spaghettidba (12/10/2014)

SQLRNNR (12/10/2014)

andrew gothard (12/10/2014)

Aye - I've got one of those too. Even better - unless I've completely misread the trace, someone - somewhere read that "SQL...

It's the NULL value that breaks the function.

Try this:

DECLARE @val nvarchar(max)

SELECT TOP(LEN(@val)) 1 AS one

Results:

Msg 1014, Level 15, State 1, Line 3

A TOP or FETCH clause contains an invalid value.

It's a crosstab:

SELECT SUM(CASE WHEN prt_created = lastMonth THEN 1 ELSE 0 END) as lastMonthData,

SUM(CASE WHEN prt_created = currentMonth THEN 1 ELSE 0 END) as currentMonthData

FROM PARTICIPLES

Hope this helps

My bad, I totally misread the question.

Gazareth and Perry are right:...

SQLRNNR (12/10/2014)

andrew gothard (12/10/2014)

Aye - I've got one of those too. Even better - unless I've completely misread the trace, someone - somewhere read that "SQL Server works better...

When P is P, nothing happens.

When M is P, no automatic failover occurs.

It doesn't appear there is much to do to convert from varbinary(max) to XML;

DECLARE @test-2 TABLE (

varbincol varbinary(max)

)

INSERT INTO @test-2 VALUES ( CAST(N'<XML><!-- A comment --></XML>' AS varbinary(MAX)))

SELECT CAST(varbincol AS...

Use the Data Collector.

It's available in all editions (express excluded for lack of SQLAgent) and it's the evolution of all the tools you mentioned. Vast parts of SQLDiag and...

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1641725.aspx

This should do the trick:

WITH SampleData (AccountNo, OpenDate, CloseDate) AS(

SELECT 1361677, '20121203', '20140102'

UNION ALL SELECT 1361771, '20121205', '20130219'

UNION ALL SELECT...

Post your script please.