You need to change compatibility level to 100 to use MERGE because it was implemented in 2008. Check below for details.

http://msdn.microsoft.com/en-us/library/bb510625.aspx

I am not sure what you mean but MDAC actually comes with the operating system, that is the reason if you are in Win2003 you need to be in SP2...

Jack,

I think the person is talking about my solution but I still thinks the vendor of the software should be contacted if their developer wrote crappy code.

That is correct you need admin permission to all the drives SQL Server is installed because you may not able to perform some tasks and troubleshoot issues that will require...

Let explain your error what it is saying is you have the SSIS runtime in Work Group edition but you are using features that is only supported in the Standard,...

The most important features differences in SQL Server editions is in BI stack and replication, if you are not using both install the 2008 standard and move databases and objects.

If you are not using many temp tables in the code you could use Table Variables instead of Temp tables.

I think you need to admin permissions and if the user is running SQL Server Express you have to give the user the permissions or you have to be ready...

You need to go into configuration manager and make sure you are using the network service account for your SSRS account. I also don't understand what you mean because...

Then you may have to try to modify the schedule if that does not work then you have to create a new one this is assuming those issues are not...

It may be related to what Microsoft is saying in the late breaking changes below however I need to explain the technical issues better than Microsoft Win2003 comes with IIS...

Security is (almost) non-existant. Hosting companies are big fat cows just waiting for hackers to milk them. One lucky break and a dozen company's data could be stolen. And then...

Yes those services let me tell you about how these could cost small businesses that decides to take the advice in the article I posted, during one of the migrations...

chrise (4/13/2009)

---

If you take the example quoted by Amazon, a medium sized website db of 100GB and averaging 100 I/Os a second over the course of the month, it would...

Actually VS2005 Team Suites require a separate download to get the DB pro edition features I know because I did it in 2007. In VS2008 you also need the...