Two things. You will need to script everytyhing from your SQL Server 2005 Express database, ensuring you do so for SQL Server 2000. This shouldn't be a problem...

Hard to read the error message. Just a guess at this point, but it looks like it couldn't create a subdirectory. Two possibilities, permissions or lack of space.

That could be quacking I hear in the background. :w00t:

You can't backup the transaction log of databases using the simple recovery model. In addition, master can not be changed from simple recovery model.

You should seperate the system and...

Given A date return the number of Sundays? Doesn't make sense.

Use isnull around each column: isnull(columnname,'')

I am curious as to what your error is. While looking at the code in your original post, I also noticed a "go" where you probably don't want one....

No, you can't define PK/FK relationships between tables in different databases.

Now for a dumb question, why are you using dynamic sql in this to strip the time.

/*

declare @sql as varchar(255)

declare @table_var table (data datetime)

set @sql='select ''' +...

Jack beat me to it, but you can also learn more about the patindex function in BOL (Books On-Line).

Sorry for taking a lot of space, but check out the following:

--We need to build a new ptEncounterEncounterDetail from the EncounterID,

--EncounterDetailID combinations where the Migration values are in the

--old ptEncounterEncounterDetail....

Also, I assume that ptEncounterEncounterDetailTemp has the same structure as ptEncounterEncounterDetail?

Just one thing missing, what should the expected results be based on the test data. Need something to check against.

new coder (10/30/2008)

---

Hi, I have a table let's call it Person. This table have many column, among which are 3 that I need to check their values.

1-Cell number

2-Home number

3-Work number

For...

Is the new filegroup on the same disk as it was before, or did you move it to its own drive? I'd probably move the nonclustered indexes to the...