Roll-back Transaction will only roll-back data modications and will not affect the values in local variables.

so @n stays = 112

Inner Join is the ANSI standard and has been for a number of years.

The other way will not be supported in the future, so probably best not to begin using...

Writing a procedure that simply inserts the data into one table from the other will be faster than writing to a flat file first.

you can either write a procedure or...

have you removed the replication?

You could use the copy database wizard in SSMS to copy the database, and then save the package and use this in SSIS.

Once you have created it locally and are happY with it, then you will have to re-create it on the hosting server.

If you are only interested in moving the...

ETL refers to Extract, Transform , Load

and it refers to the process of moving your data from your various...

It looks like you are conntecting using named pipes, have you enabled this in SQL configuration manager on your server?

There a lot of different things you can do to optimise a query, fromm removing cursors , correct indexing and reducing the number of columns selected.

Post up a copy of...

What do you mean by , tables that you create locally?

Does this mean tables you have created on a local server on your machine?

Sql server operates in a client -...

Replication is used when you have the data pushesdacross form one server to another, for example you could have an Admin system that populates a database every time a...

SQL server express can act as a subscriber in replcication but does not have the ability to act as a publisher.

Replication is a specific term in SQL, and is different...

To load 20 seperate files at the same time you will need to use the For.. Each loop container to loop through the files and load them up

As others have said, I think Backup and Restore is the best option.

Log Shipping would add an unnecessary overhead to your production server if the only reason you are...

It is generally accepted that it is better practice to store images on the file path,

Security and backups are two things that you will have to take care...