Do you use Windows Authentication for your connections?  If so, make sure the login used by the SQL Server Service has permissions for each connection/server.  If you run the package...

Try this.

DELETE stg

FROM (SELECT Service_Tag, MAX(id) mid FROM ServiceTagReport GROUP BY Service_Tag) a, ServiceTagReport stg

WHERE a.Service_Tag=stg.Service_Tag

AND a.mid<>stg.id

Brian

Have you checked to see if there are any scheduled jobs that run during these lockups, both SQL and non-SQL jobs?  Do these lockups coincide with anybody's daily routines?  Can...

Are you talking about disk size or row count?  sp_spaceused tablename   will tell you the size of a table.  As far as restricting the disk size, the only thing I...

If you do it in EM, I believe it actually creates a new table, copies the data to it, drops the original, and then renames the new table and creates...

TIMESTAMP is just a BINARY(8) value.  If you do not need the funtionality of Timestamp in the second database, create the columns as BINARY(8) instead of TIMESTAMP.  You can then...

What happens if you do an update without the join? 

 UPDATE Services

SET Services.LagCategory = ???

WHERE

Is LagCategory in any of your indexes?  How long does it take to load the data? 

Are there any triggers on the table you are updating? 

What happens if you change your options to scroll results as received?

Tools, Options, pick the Results tab and check "Scroll results as received (*)"

Brian

Why is

create index ix_cover on products (productid, product, cost) include (productdescription)

better than

create index ix_cover on products (productid, cost) include (productdescription, product)

I created a table that had...

Can the Exchange administrator check out the profile and see if it is actually sending out the email?  What happens if you copy the email address from the operator and...

From Outlook, can you successfully send an email to the address assigned to the operator?  If yes, can you open Outlook with the profile used by SQLMail and send the...

AND OeOrders.OrderDateTime>CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120))

This conversion will remove the time from the current date.

Brian

The last record will be inserted because the temp table is empty at the time the query is executed.  If you execute each statement individually by left joining it to...