We currently roll out both software and a back end express instance. This can be run remotely or on the local machine. The user has to be an...

I should mention that I would use Bulk and SSIS if those options were not off the table. Since bulk can be tricky permission wise on remote upgrades we...

Thanks for that help. It is the Schema that is not scripting out which is a bug but I can work around. When looking for the constraint I...

Agreed Check constraints seem to work for me also. So I will rack it up as a bug

Thanks - In a SQL weekend class they said multiple DML statements ruins the procedure cache and slows it down. That separating them was needed for SQL to know...

Yeah when you said that I thought about it you are for sure correct thanks

This is actually what it needs to be. I finally got around to debugging it. I was missing a comma before and after. If there is a more optimal...

I know that function and love it. The result set should not look like that though.

Not this:

1

2

3

4

but

1 | 2

3 ...

In this case a nvarchar(max) is not necessary but used for "Future" possibilities. So I can limit it.

ok I understand what you are saying. Is there anyway to create a DB on 2008 and still be able to restore it to a 2005 engine. Meaning...

The compatibility is set to SQL Server 2005 (90). That is why I thought the .bak would be formatted correctly using the backup utility from SQL 2008 R2. ...

Can you explain how you are doing that because I can not get it to work and it is frustrating. My database is 2005 compatible but was created on...

From what I see you are correct and there is no way around it. So I installed SSMS express 2005 and did the backup. Then it works

I am thinking it is a SQL 2005 SSMS vs SQL 2008 SSMS issue because I am getting that error now. The DB is 90 but because it is...

I just looked at the implementation of the tally vs the while loop and it is significantly better .