Thanks for information. Is there a way to write an SSIS which reads a table columns from one SQL server and transfers into another SQL server? I do not wish...

Thanks. There are about 150,000 rows with same type of urls that I gave you. The pattern is similar. I worked your new code. It gives me correct ans when...

Thanks a lot. Can we have say a replace with '' for things that follow with ?. And then use your logic?

Yes, some Urls have different patterns. It is not consistent except that there is .asp in all the rows. Here is some example:

http://www.xyz.com/tyeocpoute/mailserverices.asp

http://www.pqr.com/typecm/allofthem.asp?Info=4Fhs+fyOPWQRTcxcT

/errorpages.asp

/trwmjh.asp?Info=m/Txnxt1AKNvdWkS

http://www.xyz.com/hhhnnnnn.asp?Info=sHIHAfMVQY++zIeC

Notice only...

Thanks. This works fine with 1 input. However, when reading all rows from column name, I get this error: "Invalid length parameter passed to the SUBSTRING function"

no all of them will have .asp as extension but the part before and after it would change. I do understand that .asp will be my driver. But the length...

well, replication of a day's old data as backup for any disaster recovery, just in case.

GrassHopper, You need the DBA to create a linked server for you in order for you to use Openquery in your select stmt.

Thanks, but I was looking for a recommended one

...

Hello Welsh Corgi,

I did try with SSMS. That where it asks for path of the same server. Maybe I will try to script it and then tweak it to the...

Hello Ninja,

I have got the backupfolder share. But the thing is if I follow the wizard to restore, it points only to the folder on the same server and...

Thanks for all the replies. My issue is resolved. It helped

Thank you very much for replies. It helped.

My question is after running the queries, how do I bring back to multi user mode? Does it stay in Single user mode?

well it is a test server and not in use. So didn't take it offline nor put it in single user mode.

My Q is that the weekly backup used for...