Thank you!

Clustering, like mentioned earlier, is more for uptime. If one machine fails for any reason, the...

Just when you think you're done...another road block!

I want to save the results to a table, so changed it to the following:

DECLARE @ServerName nvarchar(30)

DECLARE @sql nvarchar(max)

set @ServerName = '[server-a\testdb]'

set @sql...

Sure did. In my case it...

It worked!!!! Actually, the key was using dynamic sql. This is the end result..

DECLARE @ServerName nvarchar(30)

DECLARE @sql nvarchar(100)

select @ServerName = '[server-a\testdb]'

set @sql = @servername + '.master.dbo.xp_fixeddrives'

exec(@sql)

Thank you for...

Thank you for the info! I will try this now and let you know.

I could not tell what was running from any of the logs and it only happened once.

I will review the link...

No, CLR is not enabled.

You can tell by clikcing Start->All Programs->Microsoft SQL Server 2005. If you see SQL Server Management Studio in the list, then you have client tools installed.

Thank you. What's the best way to contact them?

Ok, most of what you said is out of my area of expertise, so I will have to get help on it. That being said, I am able to...

Oh, ok. I see the difference now!

Thanks.

I'm trying to determine the difference between a differential backup and a transaction log backup (as stated previously, SS only has differential, not incremental)

That's a good question! I thought I knew the answer to it, but I think not?

transaction log backup - backs up the transaction log (which holds transactions since the...

If you are asking if folders on the server are shared out that I can access, the answer is yes.