Got the answer - As is is default instance - sql server inherits the computer name.

Thanks

Thank you so much for the options. Can I get some more insight of this can be done using SSIS.

As I tried and wasn't successful.

Appreciate your response.

Thanks,

Swetha K

Thanks Parthi. that was really helpful.

Thank you for your time & prompt response.

Swetha K

I have exported the data from excel as table and tried converting data.

source table has data in '10:15 AM' format and destination table has time column as nvarchar which shouldnt...

I am using a script, I need to insert into the datatype nvarchar(50). I shouldnt be changing the datatype.

Thanks,

Swetha K

I tried to do SSIS but, had errors because of the indexes.

but I am eorking arround those issues.

Thank you all your replies.

Swetha K

I took a full backup of prod database, tried to restore using wizard and the error message is :

The database was backed up on a server running version 10.50.1600. That...

I tried,but it gives me the same error ..

Please suggest.

Swetha K

When I hit deploy it gives me error " The specified report server URL is not found. Verify the syntax of the URL and that the report server exists."

I have...

You were correct SeanLange.

Thank you very much for making it obvious... & Thanks to all who took part in resolving.

Thanks

Swetha K

Hi Parthi,

I have checked your approach but if you can check the following (Please let me know your inputs as I am stuck with the a...

Doesnt give any error but doesnt insert

IF EXISTS (SELECT * FROM dbo.fileinfo U INNER JOIN dbo.[File] A ON U.filename =A.filename )

BEGIN

...

Insert statement has no issues only issue is with the else part ..

I tried using Merge statement but because of few columns which has partition imposed on it, Merge statement doesnt allow.

So, I had to use IF ELSE ..

Swetha K

I tried doing that .. but wasnt successful..

I am not having any idea of where is it going wrong.. your suggestions would be helpful..

Swetha K