Based on the code provided, the update is outside of the set @SQLCmd

Do you need the UPDATE to be inside the variable so that you execute the use and update...

You will need to manually create the backup command passing in the UNC path

Something like

BACKUP DATABASE database1 TO DISK = '\\SERVER\share\database1.bak'

You can manually type in the UNC path to the...

If you have the media for SQL 2005 you can install just the workstation components wihtout installing the server objects.

If you install express, yes there is a limit to the...

These will be good places to start

http://www.sqlservercentral.com/blogs/robert_davis/2010/06/15/Building-HTML-Emails-With-SQL-Server-and-XML/

http://jahaines.blogspot.co.uk/2010/04/t-sql-tuesday-005-creating-emailing.html

I use the second one for a number of reports in house.

If you want to monitor the execution of packages or manually run the packages outside of SQL Agent then yeah you will need to change the config file on all...

If the upgrade is in place, it will upgrade the databases for you, but if it is side by side then no, as with each release of the product the...

Yes dettach attach is a supported migration path, just remember that once it is done it cannt be undone.

How have you definied that it is the order by which is causing the problem?

Please follow the links in my signature on posting performance problems and data and code for...

Can you post the proper select statement which encorporates the function call?

Also have you determined if the function can be changed into a inline table function, instead of a scalar...

This is a problem with iPhone / iPad, if SQL is sending the mail and it can be viewd via outlook OK, then the problem is not with SQL or...

This will hopefully help you in troubleshooting connectivity http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx.

If the client cannot ping the machine by name then that is the reasoning behind it not connecting.

If it can ping the...

If its a windows application, being run as an exe by a logged in user, then the user who is running the exe needs to have access to the SQL...

If you are running them as jobs then you dont need to do anything to the configuration files. Just ensure that the SSIS service is started on both machines,...

How are you running your SSIS packages?

If they are being run by SQL Agent job you dont actually need the SSIS service running.

If you are running them manually via SSMS...

Can the server where the app is running from ping the SQL server? Is the database POS online? Does the user running the service have access to SQL?