I disabled the jobs on *Server 2* where I am restoring the database.

Yes, that's what we are currentlly using, but it is giving unexpected result sometimes -

for instance -

- IsNumeric(x) returns true - when varchar value has both comma and a tab...

yes, I had already tried that on an untyped xml column but mine is typed here 🙁

Thanks for you reply.

But why I am getting this error, is it because schema is associated with 'xmlMenu' column?

Yes, I tried browsing for available servers.

Hello Flo,

Thanks for your reply too.

I am able to get the server name after installing Express Edition.

But I wonder why Management Studio was not able to get local sql server...

Hello Steve,

Thanks for your reply.

Both application and SQL Server are on local machine and I was just simply trying to start some test application.

Now, I have downloaded SQL Server Express...

Hello randal.schmidt,

In SQL, you can duplicate row by using following command:

Note: I have taken example using database.table = Northwind.Products, you can modify it as per your need.

INSERT INTO products (ProductName,...

Thanks Leo for your reply.

I have downloaded Management Studio and able to work with my database with this tool 🙂

Cheers!