I use redgate SQL Compare and SQL Data Compare for this. The tools are well worth the investment.

It uses the last modified time of the file - and deletes any files older than the criteria you set at the time the task runs.

I would not recommend deleting...

Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response :w00t:

http://www.sqlservercentral.com/Forums/Topic697843-146-1.aspx#bm697863

Really - let me...

If you are seeing this message in your logs, then you have a user/service/application trying to login to SQL Server using Windows Authentication when that user/server/application has not authenticated on...

Yes, you are trying to login with Windows Authentication when you are not authenticated on the domain. Either authenticate on the domain - or, use Runas to run as...

And what about the case when you have information in the header record that needs to be associated with the detail records? For example, if we have an employer...

You are welcome and thanks for the feedback.

Probably - but not without a lot more information. Please review the article I link to in my signature. This article will show you how to post your...

Yes i am running steve's code and still i get 2251 records.

I examined the result and the code is picking up all possible matching suitid so I am getting...

Sponge (4/14/2009)

---

Steve/Jeffrey:

Thank you very much for your reply. Steve: To answer your question I am using a mainteance plan so the backup actually dumps first and then perges...

andrewd.smith (4/14/2009)

---

Instead of the ROW_NUMBER() function you can use the TOP 2 clause in a derived table to get the 2 most recent rows.

SELECT MemberId, AVG(LabValue)

FROM (

SELECT...

Well, do you want the last two months average - or the average from the last two entries? Is it possible that you could have results for the last...

It is a...

Select Memberid, avg(labvalue)

From MemberLabResult

where labid = 1

Group by Memberid

Having

avg(labvalue) > 4 or

avg(labvalue) < 4

Add your date filter to the where clause:

WHERE labid = 1

...

When you take a resource offline in cluster administrator - it is the same as stopping the service. It is a service shutdown - and yes, the system will...