Hi

Just wanted to let you know that the issue is solved.

I deleted the rsa user from Server02 and created again with the same sid from Server01.

create login rsa with...

Hi

Thanks for this one . But it says the following when i try

Failed to update database DB2 because the database is read-only

Any other solutions.

Hi

Oops i think i was not very clear

I have a column which has the following values

00_MECH_UG

00_PRE_LW

EN_CVLG_UG

I would like to have the result as

MECH

PRE

CVLG

Thank you so much....that did it....it was hiding there...

appreciate your help...

DOne.....thanks so much for that query/....appreciate it.

arun i would really appreciate you put a small

query for that one and let me know please

i dont want to change the schema

Hi Robert

When doing transaction log shipping and choosing the Database Option as Standby/Readonly, the users will get disconnected when the last step of restore is being done.

I have tested this...

Hi Robert,

All was working fine until i started to use the Portal Software on the secondary software to point to the Database(Read Only-the one which is used for Transaction Log...

Hi Robert,

Thanks for the reply . Please find these results

When i am trying to access the Shared Folder on the Primary Server from the Secondary Server, it is not asking...

Hi Robert,

It does give me the name of the servers but not from that command.

select * from [log_shipping_primary_databases]

select * from [log_shipping_primary_secondaries]

that does give me the names with the same primary...

Hi Robert,

sorry for that....

it does give me the names of the Primary Server and the secondary server with the

Hi Robert,

From the Secondary Server , i can access the shared folder \\Primary Server\Backup but i have not setup a trust relationship with the 2 domains. I did not...

Could someone please help me out.

Help very much needed

Hi Lenny

Thanks for replying. Please find your queries answered below.

The xl sheet is populated in the following way using the code

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=D:\Book1.xls;',

'SELECT * FROM [Sheet1$]')

select *...

ho ...ho.....

I just got lively back into this again.....

thanks for all the wonderful scripts......

we were kind of having problems at my end....

Now i will check the scripts now and i...