Hi,

Could you please provide some contact details to send my CV to?

Thanks.

Hi,

I have just created a Primary key on the table where the data is being selected from, and also the table where the data is being inserted into, thus creating...

Hi,

Thanks for getting back to me, to answer your questions ....

1. Could you post all of your code so we can see where the BEGIN TRANSACTION, etc statements are?

I have...

Thanks Noel, that worked a treat! much appreciated.

Thanks for that, its greatly appreciated, I'll get it tested and let you know.

Chris.

Hi,

Thanks for that, I do know the new server name but I don't know the old server name.

Hi,

Basically when we restore a database from another server we need to check a certain table in the database (this table tells the application which database server to use).

Therefore, when...

Hi,

I can't post the actual server names, the server name is always 18 characters long.

I was hoping to test the code using SERVERNAME and then put the code into a stored...

Hi Phil,

Thats worked a treat!!

Thanks for your help, it's greatly appreciated.

Chris.

Hi Phil,

Sorry to be a pain (I am trying to figure this out myself).  When I execute the following code ...

DECLARE @strSQL nvarchar(4000)

DECLARE @sql nvarchar(4000)

DECLARE Localisation CURSOR FOR Select...

Hi Phil,

Thanks for your help, the cursor is pretty much doing what it's puposed to do

The only problem is that for some reason...

Hi,

If I just use the following it works fine, whats the best way to put this into a cursor so that it will loop through all the rows in MyTable...

Sorry, missed that bit out .....

DECLARE @sql nvarchar(4000)

SET @sql = (Select [Statement] + '''' + [ServerName] + '''' + ', ' + '''' + [ReplaceValue] + '''' From MyTable)

DECLARE...

Hi,

I've even tried inserting the entire string into MyTable2, and then running ...

EXEC master.dbo.xp_execresultset 'select * from MyTable2', 'MyDB'

And it returns the following ...

Server: Msg 156, Level 15, State 1,...

Hi,

Thanks for that.  I've got an error ....

Error converting data type varchar to bit.

Any ideas?