SSMS, along with Redgate tools.

Adam

Happened to me just the other day! Took me a while to figure it out 🙂

Thanks again Gila and all - the problem is now fixed.... 🙂

I ran sp_removedbreplication 'mydatabase', 'both';

then DBCC OPENTRAN showed no active open trans and I was then able to truncate...

Big thanks to Jason, george, Gail and Paul - I think Im getting somewhere.. 🙂

log_reuse_wait_desc shows : REPLICATION

dbcc opentran shows:

Replicated Transaction Information:

...

No I didnt try it - but I did read carefully through what it was going to do - the log file will not shrink below 90gb and we have...

Thanks for that but this wont work in this case - we have already tried shrinking and truncating the Log - and it will not go below 90GB.

I think the...

Yes sorry, I should have used the word Shrink instead of truncate in my post - the log file wont shrink below 90GB.

Re: Sending SMS from SQL Server

I have use a couple of approaches successfully:

1. Use SMS provider who can give you an SMTP Gateway (nearly all if them do!)

2. I have...

Hi

I still find I need Cursors when Sending out batches of Email notifications from the Server.

For example:

1. A scheduled Job selects records of people who need to be informed of...