How do you know I'm not crazy? :w00t:

vision59 (10/29/2009)

---

Thanks for your suggestion Jeffrey. You are right it works great for table by table process. I want to add new rows based on primary keys in database...

vision59 (10/29/2009)

---

this is only one time I need to sync up some table data between database A and database B. Backup and restore will not work in my case. That...

Take a look at the following article: http://www.eraofdata.com/blog/2009/01/loginfailures/

What is stated here is that most likely the problem is this user does not have permissions on the default database. This...

Jason,

Thanks - sometimes I forget that you have to be very specific and miss...

vision59 (10/29/2009)

---

Hi abair34,

Based on ID field which is primary key in the apps how I do I browser all the tables in Database A and Add missing rows in...

SQL Server Management Studio needs to put the results of your query somewhere, so it can be displayed. Performing a SELECT everything type of query on a large table...

In SQL Server 2005/2008 you now have a Job Activity Monitor. Open that and you have everything you are looking for and more.

One thing to note is if you...

I am going to repeat what Lynn stated - and recommend that you look into compressing the backup file instead of moving to a compressed folder.

The problem you are running...

Also look up LTRIM/RTRIM in Books Online - that should take care of the leading/trailing spaces.

Steven.g.karpowicz (10/28/2009)

---

I am actually running under Network Services and not Local Systems account. It takes my Id which has permissions to the network servers. My thinking is that...

Steven.g.karpowicz (10/27/2009)

---

I guess I am confused on permissions. I think you hit the problem on the head however I am the user for SQL SERVER AGEnt so I should...

Yes, you are given the option to select which instances will be upgraded.

Before using the with init option to initialize an existing file - you really need to make sure that backup has been copied to offline storage.

Steven.g.karpowicz (10/27/2009)

---

Yes I can run the package from business intelligent studio or I can run it from integration Servives from with in SSMS. In both cases it works greate...