Also make sure statistics are up to date.  Were they on the same server?  In-memory temp tables should only be used for small amounts of data and can cause performance...

Why is it wrong?  Is it synchronizing to a time service somewhere?  You don't want it changing back again !

In this case, you just need to group by all the non-aggregated fields and can dispense with the inner query :

SELECT da.MMS,da.Zip,MAX(da.TrackingDate) AS TrackingDate

  FROM DailyAccountsDownload_Tracking da

  GROUP BY da.MMS,da.Zip ORDER...

Assume all SPs are owned by dbo.  You deny execute permissions to all users for those procedures you want to protect.  Only other dbo. procedures then can call them.

More usually,...

I vaguely recall that there is an issue with cross-domain security authentication within Windows, ie it's a Windows issue rather than a SQL Server issue.  Sorry I can't be more...

Brian, Steve has included the link to the source in his edited post at the top of this thread so its not being censored - he just removed it from...

Just a concern - quite possibly unfounded - just that I always like to minimise network traffic.  You've obviously come up with an effective workaround.  However, given the application, we feel...

[ I found sometimes just executing "SELECT USER_NAME()" would die with a "General network error" exception and close the connection ]

I tried this and got the same problem.  I haven't...

No idea whether its a factor but @Tablename is Varchar and you're embedding it in an nVarChar string.  Not sure what that does.

How many billions have Microsoft, Oracle and others spent on developing optimised relational database systems?  Why throw it all away in favour of a heavily padded flat file format?  It...

... and another illustration of why dates should be stored as dates, not character strings !!!!

Sometimes it's unavoidable but I try not to use dynamic SQL whenever I have a choice - especially if it's going to be that big !  What are you trying...

My preference would be to keep them in the database - neater and no risk of broken links.  However, zip them up on the client side first (I have used...

Remember that all tables, permanent, temporary or table variables are held in memory as much as space permits.  They (including table variables) are written to disc when memory space runs out. ...

Quite right Vladan - my brain has shut down for Christmas.  I don't think I should be coding accounts posting today - probably bankrupt somebody!  Think I'll just go home.