We don't hear that very often :w00t:

Thank you for the contribution and the urls.

keep in min to change the dblevel to 90 !!

Did you try to do it like this ?

Declare @ComputerNamePhysicalNetBIOS varchar(256)

Set @ComputerNamePhysicalNetBIOS = 'Server [' + @@servername + '] Running on - ' + Convert(varchar(128),SERVERPROPERTY('ComputerNamePhysicalNetBIOS') )

Declare @Subject varchar(256)

Select @Subject =...

It took me a lot of frustrations but I got it to work :w00t:

-- ...

If object_id('tempdb..#LocalGroupMembers') IS NULL

begin

Create table #LocalGroupMembers ( IdNr int identity(1,1) not null

, [ServerName] varchar(128)...

Advantages ?

Mainly you save drive letters

and you can use more than 26 logical drives for a single instance of sqlserver

BP say for performance you would need:

- tempdb on a...

Thanks again 🙂

It gets quit confusing (sheer volume) to find the right corner in the maze to get started. :hehe:

Thank you for your help.

I keep on getting lost whenever xml is being used with cross apply.

How does it retain the correct parent/child dependency ?

I'll try to work on this...

Nice article James :w00t:

Good overview towards the remarks and caveats.

We are using MPs for a while now (with sql2005) and didn't encouter any problems yet.

Knock on wood:Whistling:

SP3 = SP2 + cu9

SP3+CU1 = SP2+CU11 !

You can go directly to sp3 and then apply CU1 for sp3. (Current is CU2)

( http://support.microsoft.com/kb/960598/en-us )

Keep in mind...

and the client is the IP address of your sqlserver...

It has been a while since i tested with SSMA for access, but I think it has a section to handle this.

MS has some good Migration assistant software for MSAccess, ...

Check out http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx

Is sqlagent connecting to sqlserver using the sa account or using its service account ?

what's the purpose of doing that ?

If you don't want backups and you don't want PIT recovery, just put your database in simple recovery.