Well, I'm waiting for the guy to test via his application as he was getting rollback transaction errors! I may need to come back perhaps but when I do...

Hi,

Thanks for your all, I've managed to resolve it as I didn't add local.

Hi,

Thanks again. I have managed to recreate a new link and restarted sql server but when I run select@@servername I get NULL in column name?

Hi,

Yes the server name has changed. I have created a new link but the issue I have is some of the setting e.g. is_linked is 1 and is_remote_login_enabled is...

Hi Andy,

Was it this title REal MCTS by Horninger?

Thanks

Thanks

Sorry before I do this, can I replace the #t with person.address?

Thanks Frank, I'll give this a go.

Frank,

Can you start me off with the syntax?

I've had a look and I don't think this is what I'm looking for. I'll need to look into this more to find out what I want from my...

Hi Steve,

Are you able to post your script to do this as I'm very weak at coding?

Thanks

Hi,

Is this similar to ddl triggers? I'm new to sql server dba and coding is not my strongest part. I am looking for a script that will create...

Hi,

Sorry I'm new to sql server 2005 and coding is not my strongest point. Can you please point me to exactly which line that I will need to change...