Sorry, I don't understand what you are after.

We need at least an example of the expected output.

You're welcome.

Thanks for the kind words.

I guess you're out of luck. Renaming a cluster node, as you have seen, is a very bad idea.

Do you find anything helpful in the logs?

Does the Event Viewer contain...

On the target MDW database you have to add to the mdw_writer role the windows user that runs the data collection process on the source instances. If you want to...

Create a temp table and pipe the results of the procedure to the table.

Then you can query as you prefer:

DECLARE @return_value int,

@endYear SMALLINT = 2014,

@CustomerID INT = '9999',

@Schedules CHAR(1)...

SQL Server never releases the memory it uses, unless told so by the operating system.

Your ERP module is not your SQL Server. When you close the application, SQL Server still...

BTW, there's an undocumented system extended stored procedures that happens to do exactly what you're after:

EXEC xp_sqlagent_enum_jobs 1, SUSER_SNAME

Wild guess: daylight saving?

Hard to tell. Stored procedures are compiled against the first runtime parameter passed, which are cached along...

Reading the output stream from PoSh is a pain in the rear.

I would script the logins using TSQL instead:

SELECT 'CREATE LOGIN ' + QUOTENAME(name) + ' ' +

...

Don't use OLE objects to send mail in SQL 2005, use the Database Mail feature instead.

However, if you're sending emails from an application, you'd better use a full-featured smtp client...

You can query the sql agent job tables in msdb

Or you can use a tool such as sqljobvis

It might have to do with the actual parameters passed in. Have you checked that?

SET DATEFORMAT mdy

DECLARE @test-2 TABLE (

Site_id int,

product_id int,

mode varchar(10),

quantity decimal(9,3),

date_of_issue_return...

Do you have any counters that suggest you have disk issue?

Have you tested a typical workload on the new storage? How did it respond?