WOW 400,000 members. Seems so small when you consider other sites have more....but when you realize that this site is a tech site for a VERY specific product, that...

Check out Red-Gate's SQL Data Compare. It's a wonderful tool for checking out and 'fixing' differences between two databases.

You tell it which two databases you want to compare and...

There are just too many 'exceptions' or unusual names for something like this to work well. We've only been discussing 'english' names....what about foreign names or made up ones...

Steve et al,

THANK YOU. I know I 'gave you a hard time' and was probably 'being a pain in the ...', but you listened. The change happened and even though...

Steve et al,

THANK YOU. I know I 'gave you a hard time' and was probably 'being a pain in the ...', but you listened. The change happened and even though...

You are correct. And wrong.

Correct: You won't have a tlog backup saved off for that timeframe.

Wrong: One step that is usually overlooked when things go wrong is to IMMEDIATELY disable...

Go into the Job and check:

1. On General Tab...who owns it. Do they have permissions to run it.

2. On Step tab....expand each step...is it running in the correct database.

3. On...

sushila,

Because I believe that a site should show who the actual owner is. There were 'anti-Red Gate' postings when Steve, et al, announced the sale. Besides Brian of ApexSQL, there...

The REINDEX will fill up the tlog. It has to. REINDEX is all or nothing, so if it fails it needs the tlog to rollback everything.

Okay, you have a REINDEX...

No problem. You won't hear from me anymore about this. I've had my say and you are considering it. That's all I ask.

Thanks,

-SQLBill

Thing to keep in mind with Single User mode.

Stop SQLServerAgent service. That controls the jobs. If a job starts up - that's one connection. Or disable any jobs that...

Now that they've said that...yes you MIGHT be able to recover the data. Since deleted data really isn't, it might be able to be recovered from the disk(s). If...

Or:

select a.* from tbl_a a inner join tbl_b b on RIGHT(a.col1,3) = b.col1

-SQLBill

My issue is that the only thing I see on the page is the Supported by Red-Gate software. I don't scroll all the way down to see the copywrite information,...

My issue is that the only thing I see on the page is the Supported by Red-Gate software. I don't scroll all the way down to see the copywrite...