Thank You Gail for the reply...

So then the answer to my question is Write Through? In the event of a failure and no battery-backup cache, I will not lose...

I think I am getting things confused here...I am talking about Transaction Logs (WAL) and what I care about is what SQL Server prefers with caching on the RAID controller....

Thanks for the reply Calvo, while I 100 percent agree with you, that is not how our clusters are set up. The information within my Node1, Node2, and the...

Thank You Erland...

The intention is to loop over each Linked Server, run the transaction for that Linked Server, and then fetch the next Linked Server. That being said, I have gotten...

Chris, Thanks for the reply, but why would I need to check the firewall settings, when I can run the old SPROC that hardcodes everything (it works fine) and when...

The SPROC being called by the Dynamic SQL is a gathering metadata about each database on a Linked Server. The reason for this, is that we are undertaking a...

Lowell and Ed,

Thanks for the replies, I will try to better explain what I am doing and what I am looking for.

What I am doing: I have cursor...

Thank you so much Howard! I really appreciate it...

I give up too easily and over complicate things, I believe I have what I need below:

SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 18, 0)

Thanks

Thanks to both of you for the reply...

Lowell, yours works perfectly!

Thanks Again

Thank You everyone for the replies...

Thanks for the reply OPC...

I did try that method as I researched out to get this done. My problem that I had with it, is that the File System...

Nevermind, I was making this harder than it should have been. I thought I was going to need an expression for this, but it was simply a check box...

Thanks Mister.Magoo...This is new a database I am not familiar, there was already a Phase Order defined, once I added that to the dataset all was good.