If currently the data from DB2 is being loaded nightly, why is there a need to hit it dynamically now?

Also your biggest hit as a percentage of the query plan...

Please do not cross post. Original post is here: http://www.sqlservercentral.com/Forums/Topic539275-1063-1.aspx

You do not have to drop the Primary Key constraint on table1 as you can update values in a Primary Key Column. Have you attempted to isolate the alter...

It would be easier to read your execution plans if you saved them as .sqlplan and attached the files to your post. Then we could open them in SSMS...

I'm...

Dev (7/22/2008)

---

Hi,

My requirement is to compare count of a table between a hour difference and if it remains same i do the next task.

For exapmle, here in the below...

Are you getting it for any other Windows user or group? Can you get a test Windows user setup for you to experiment with? Do you have another...

Not that I am really advocating this, but you could put a trigger on the sysjobs table in msdb that logs changes. There actually is already an insert, update...

Jeff,

When I run it the only difference I get is on the first one where there are no duplicate addresses, so depending on how you code it you get a...

tfifield (7/22/2008)

---

I haven't used DB Mail much yet in 2005. I have it working and it seems to work just fine with 1 little draw back.

I've been through the...

Sure, but it applies to ALL user tables in the database. Using the datareader role is usually a...

This would work but provides more

than the minimum rights,...

ctics112 (7/22/2008)

---

Jack,

My apologies for not explaining the situation thoroughly. The stored proc is returning agents from states other than TX, FL, and LA. It is just that those states are...

You need to include the data type before the not null.

Alter table dbo.table

Alter Column column_name Int Not Null

DBCC ShrinkFile ([log file name]). Check out BOL for the rest.

You normally do not want to shrink the log as it will typically just grow again and the growth...