Or similarly (borrowing Govinn's temp tables + data - thanks for that!!) 

select 'Customer' as [Table], C.Value
FROM @emc_messageinfo E
  INNER JOIN @Customer_mast C
   ...

One of the first rules you should observe with database transactions...  They should be

AS SHORT AS POSSIBLE...

This means that you should never have any user interactive process that keeps...

Govinn is right - you'll need to use dynamic SQL...  This means that the security context of the user executing the statement causing the trigger to fire will be used,...

I should state that if you have an identity column on a table and insert the rows in a particular order then you will see them ordered sequentially in the...

Do your IIS logs have anything of interest in them?  You could have IIS log a lot more info and see if there are any connection dropouts, etc.

Yes quotename is a nice way of doing things, but bear in mind it has a limit of

nvarchar(258)

so you probably are better off using a UDF so you don't get...

Very quick google search returns MANY relevent hits...

Look at http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20629811.html

Or, for a tutorial approach.

http://msdn.microsoft.com/msdnmag/issues/0800/cutting/

Happy reading

Firstly, there is no guaranteed order that data will be returned in when selecting unless you use an ORDER BY clause.  You see the same order on your simple select...

Can your device copy a 1-2MB file successfully in an appropriate amount of time?  I've seen some connections on desktops (not much experience with handheld and VPN though) that would...

MSDE / SQL Express also have a database size limit of 2GB...

But good article - nice to see comments & discussion on running smaller SQL Servers on a budget!

You could always script out your logins and then just backup/restore or detach/attach your database rather than scripting out all of your database tables..  You'll need to use the sp_change_users_login...

I've never been involved in anything quote as large, so I'm curious to see what others have to say as well..

But, I would suggest that you have the transaction log...

A good overview of some of the issues with encrypting data in the DB.  I might just go order the book in a week or two and give it a...

Nice article and useful procs

Any thoughts on adding transaction log backups to the mix?

You have SP3 installed... Could always try upgrading to SP4?