I don't think the checkpoint is needed. Once you switch to simple mode, a checkpoint will get run and until the full is run, you might be stuck.

Note that once...

I flip through the emails I get to keep up. That and the "Active Threads" to the left.

Not sure about the RSS. There might be some authentication here that's needed....

Basically you can use the stored procedure sp_msforeachtable and pass in a "SELECT * where TESTID = xxx" for this. you'll get a series of result sets, one for each...

Two things,

1. do you have rights for this? Sysadmin or serveradmin rights?

2. What code did you run?

You should post the code you're running, some sample data, and where the dups are occuring.

I might change the "in" to an = as well

Please update this if you find any issues. It would be good to know if there is anything else you find, other than what Jason noted.

Yep, I've seen lots of questions like that. So often management doesn't want a better solution. They just want one working, and having you move on to something else.

It is...

Or just a

select top 1

max(date), col1, col2, col3

from mytable

group by col1, col2, col3

C'mon, Roy. They're not jokes. We reported some amazing news that day. Check it out. http://www.sqlservercentral.com/NewsletterArchive/2010/04/01/4786352

New .ZIP uploaded with the file in it. Appears to download and open for me.

Steve Cullen has good code. I'd wrap that in a stored procedure, make the minutes a parameter to the proc, and then schedule that in SQL Agent as a job.

Here's my neighbor's lean-to.

Mine survived :). I don't think he engineered his enough. butt jointed 4x4s for the roof, screwed them in. Not much cross bracing.

Wind.

The Weather Channel icon was 3 horizontal lines. Gusting to 40 today.

The dtsx is now attached to the article.

Did you detach/attach the files? If so, then SQL Server should have rights.

You can check the rights on the original folders and then set the new ones. I believe that...