Thanks, but that's not what I'm looking for. I don't need it to be equal to a specific value. I just need the cluster name.

Already seen that but Im not looking for a list of values. I just need the name.

            
June 7, 2017 at 3:11 am
            
#1945745

            
            
                                                
        

Create an Agent Job to execute a script containing the object definitions each day. Alternatively, run a windows batch file to execute the creation scripts.

Thanks

Ok thanks.

Thanks

Thanks for the reply.

Would you agree with the following event taking place when a modification is made:

1. A BEGIN TRAN record is written to the T-Log in buffer memory

2....

Thanks

Thanks for your help. I'll take a look at BOL.

Thanks for the reply. I havent tried it yet, as Id like to update it and maybe add some more functionality. Are there any articles you're aware of where I...

Thats great, thanks for your help.

I use auditing tables for capturing data changes. The auditing tables are updated via triggers whenever an insert or update occurs. The Inserted/Updated rows are copied from the base tabe...

No problem. Thanks for your help with this.

Hi Grant,

Thanks for your reply. Doesnt this trace only apply to hotfixes? I was under the impression that Service Packs enable this by default. I believe this is also what...

Ok, thanks for your help.