That's bad. If nothing is changing in full backup, then it shouldn't be required to restore before each differential restore...

Great Sir. it worked. thanks

Lowell (6/27/2013)

---

ahh, i see it now;

objectname is fine for objects, like tables/procs(anything that exists in sys.objects), but you need a different field in the xml data...

Interestingly I got this script from one of your script for tables and modified it for database. While pasting here, I missed the part that you added. But after all...

Check that password is not being changed..

Gail

Although its an old thread but i don't see an option when I install with my SQL 2005 32 bit installer,to make it 64 bit.

it plainly installs 32 bit sql,...

This worked...thanks. Didn't try the job one. But thanks for that as well..

happycat59 (6/17/2013)

---

Have you tried putting your code in a stored procedure and using the "EXECUTE AS" option in...

it has to be real time as the package will pull some data for user and put in other tables.

Multiple user is no pbm as we have restricted users to...

But it will put lock on entire table, right? whereas I want to lock only the selected record.

So that noone else is able to select it.

ChrisM@Work (6/7/2013)

---

You might consider something...

Hi

There is nothing currently at App side which can prevent 2 users fro simultaneous update.

It has to be handled from database side. The SELECT subquery selects the unassigned...

Thanks All. for someone who falls on this thread, I did:

1.create new table with same structure

2.Move data in new tables in batches of 1L

3.create all indexes

4.rename table (happnened in millisecs...

Just to add, there are no insert updates on table during daytime. Only SELECTS.

Table+index size is around 25 gigs. So building new table and indexes will take hours. But you are right that atleast it won't have impact on live server.

No. None are there.

Thank You sir..

There is only one clustered index on table, no NONClustered indexes are there.

Lynn Pettis (4/29/2013)

---

S_Kumar_S (4/29/2013)

---

One question to all:

If I have data like this, where there is only one clustered...