As of now there is no proper way to quit from an ongoing restore....if anyway you interrupt the restore process, the state of the database will be set to 1...

You have the SQL Toolbelt from RedGate for that......it is surely worth paying for it.........it does all sorts of amazing stuff you want it to along with a few which...

As we might find SQL Server 2008 on our horizon, still for years to come we will be working on SQL Server 2005. This is not only because the...

I deleted the subscription and publication and disabled distributor. Then I have setup the replication once more. Now a different problem seems to crop up.

The snapshot is delivered and then...

That is true. I am already able to create the login, but cannot grant connect to the database....It says the login is not available or you do not have...

I am sorry to pitch-in late, and would like to point out an important aspect. This is strictly with SQL Server 2005. In SQL Server 2005, Microsoft have introduced a...

The situation of orphaned user will or may occur in the prescribed first two options but will not cur if you specify to copy users while copying the database using...

The process you used to transfer the data is not proper. The current stature can be corrected, but may fail at any point. So, please follow one of the following...

It worked simply because you corrected your syntax....

There was a logical error in your string....you tried to assign the value of a varialbe to the value of another...which is not...

yes...I am now thinking of using a source control.....we use VSS for our .Net codes....can you suggest any similar source control for SQL, which can automatically keep track of the...

Great...........thanks!

That was quite a good help from you.

🙂

But how?

I would like to use the transactional replication.