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...

Okay, you are storing the package at the file system - not in SQL Server itself. The command line looks okay - not sure what the problem is there.

What...

You are running Enterprise Edition (at least that's what it looks like). You can probably perform your index rebuild online using ALTER INDEX syntax. Look it up in...