Thank you Gail!

Yes, I realize that.

Thank you all for your responces.

Thanks Lowel, that explains it.

Bob, would you mind sharing how you check mount point free space with CHKDSK in Tsql ?

🙂 That should work too, you're addidng a '.' manually so that there's no error in case it's not present. very nice

Thanks

Isnull works, I like that.

Can't say that I understand WHERE CHARINDEX(...) > 0 syntax

Are they created automatically for 2008 cluster?

Andrew, not sure I understand why SPNs and kerboros will not work? Can you clarify?

Ron, I like your script a lot, and tried to adjust it for SQL server backup., I load [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") and then try the following:

# Declare SQL objects with strongly typed...

Thank you

Windows XP Professional sp3

The Config CHecker identifies the MDAC version as 2.8 sp1

Well, what I have right now is version 2.81.1132 just the MDAC connectivity, not the Enterprise Manager or SQL service. I want to know if I need to patch...

I am not able to see the code. I need to do exactly that, capture the output of SQLCMD to the variable in the batch file.

How did you end up...

Thanks Ian. So based on your reply I understand that in Bulk-Logged mode the Tlog backup will be slower, because it is during this backup that the full detail changes...

Jack, thanks for your reply.

From what I understand the problem is really that you can not do CROSS APPLY on dm_db_index_physical_stats function. Would it help if I also send in...