I've never used it in anger, but I know it's part of Ola Hallengren's backup scripts[/url] which is where I got the idea from.

If you are looking for programs that are installed then you will need to query the registry do a google on xp_instance_regread.

Rich

If you query sys.configurations this will tell you if a number of features have been enabled. You will also be able to tell if some of the default settings have...

Thanks Gail,

If anyone is interested I have raised it on connect here: Bug ID 558937.

I've run another test with some rather bizarre results. For this test I used 2 EE instances (residing on different physical machines)

The following code was run both instances:

use msdb

go

SELECT...

Wow, a reply from Gail I'm honoured :pinch:

I've had a look at the counts on our main prod server and there are 28 (all returning 2 rows) out of several...

Presumably the data from B3 had not been committed to B1 prior to B1 data being selected and inserted into B2.

Are the collations the same?

Potentially you could build an SSIS package to loop through each file in the directory and execute with sqlcmd:

From BOL:

sqlcmd -S <ComputerName>\<InstanceName> -i <MyScript.sql> -o <MyOutput.rpt>

Hope this helps

Rich

I've subscribed to KBAlertz.com[/url] choose which products you want to be notified about and you will be emailed when patches are released.

You could always just reference the table using the three part naming convention Database.Schema.Table then there is no need for a view (unless you are using it for security purposes).

Are...

Thanks Hugo, an intersting question and a great explanation of how clustered indexes are stored.

Chris Morris-439714 (1/22/2010)

Born Compton Basset near Swindon, moved to Padstow, Cornwall then Gibraltar then St Eval, Cornwall then Kinloss in the North of Scotland then Aberdeen Uni then Edinburgh Uni...

Is that link weighted towards SQL?

The first few things were:

Density

Availability

Table

Procedure

Weird!

unification

consolidation