Thanks very much for that. I shall have a look over my Christmas Break.

Happy Holidays to you

Stuart

I went through the tutorial in BOL but I got the impression (wrongly I guess) that it was to pump through changes to other SQL Servers. I wanted to update...

I will have a look mate, cheers

I'll let you know how I get on.

Stu

Hey Jonathan,

I did have a play with Service Broker and couldn't get what I wanted out of it. I haven't a clue what BizTalk is or even how to use...

Hi Jack,

I'm not using any COM objects in the SQLCLRManager.

Also worth noting is that this has been working fine for several weeks.

C# Screw,

That is exactly what its for. Auto...

The SQLCLRManager is a class that I have written that connects to my companies base framework that all of our code uses as a base.

The idea of the trigger...

There is a select statement that I have been using to determine whether or not my CLR assembly is taking the mickey with the amount of processing time it is...

Right,

I've had a success but Im not entirely sure why.

As I mentioned in the previous posts the first two transaction log backups were very small in size.

I went back onto...

BTW thanks for your posts guys.

Forgot my manners

Stuart

I checked the sys.databases log_reuse_wait_desc column and its set to NOTHING.

The database is not using replication, log shipping or mirroring.

Just isn't making sense to me.

The size of the transaction log...

I forgot to add that as this problem was reported to me I had just noticed that a brilliant article was written on SSC http://www.sqlservercentral.com/articles/Design+and+Theory/63350/ by James Rea....

Stupid Questions are ALWAYS a good idea.

No, I was try to use an after trigger. However due to the complexity, age and size of our system, it won't be possible...

I had the same thought. So I made another view based on one table selecting the whole thing.

I tried to make another CLR Trigger on that just returned a string...

Hi,

Love the script.

I had a small problem when I tried running it due to the collation being wrong. I was getting the error

Cannot resolve collation conflict for column 1...