Thank you Tom, Mohammed and Rohan for your replies. Apologies for not updating this case sooner. The issue ended up...

🙂 It's great to see this old post get so much attention. I think in the end we were able to reduce Page Locking considerably through query (sp)...

Hello,

As far as permissions go in side of the Database Server. Try to think about what the account is going to need to do. What databases/tables/objects it's going to need...

Hello RBarryYoung,

Thanks for your reply. I tested that and some other things and am still having no luck. I'm starting to think there is no way. If I set the...

Hello,

It should work. When you created the new db that created new .mdf and .ldf files. When you tried to restore the new db did you go into options...

For your login issue please try the following - Delete your user at the Database level. Create the user at the Server Level and give your self database permissions under...

Hello,

It sounds like you had an 2000 db that all you have is a .bak file of now correct? Now you have a 2005 server to restore to?

If so -...

Query:

select c.Table_Name, c.DBName, c.Row_Count as CurrentWk, c1.Row_Count as LastWk, (c.Row_Count - c1.Row_Count) as Diff

from DataRowCounts c

LEFT OUTER JOIN

DataRowCounts c1 on

c1.Table_Name...

Hi Sarath,

Do you already have the structure for the 2 backup tables created? If so then this should be a simple

INSERT INTO TABLE_BACKUP(column1, 2 ...) SELECT column1, 2 ......

Hi Gila,

Yes we are seeing occasional blocking situations occurring. I am still trying to identify the root cause of the blocks. There are definite improvements that can be made to...

Thank you for your reply! I guess to many of the readers out here my idea of a 'heavy transaction based system' might seem light. In any given second there...

Cool, Thanks man!

Hello,

If your scripting it as a CREATE you would need to delete the job prior to executing the CREATE script. I don't believe it will give you the option to...

Hello,

In SS 2005 I would go into the management studio. Under SQL Server Adent I would right click on the job you want ot copy and 'Script Job As' ->...