Viewing 15 posts - 23,971 through 23,985 (of 26,490 total)
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...
October 30, 2008 at 8:36 pm
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.
October 30, 2008 at 8:31 pm
That could be quacking I hear in the background. :w00t:
October 30, 2008 at 4:26 pm
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...
October 30, 2008 at 4:25 pm
Given A date return the number of Sundays? Doesn't make sense.
October 30, 2008 at 3:31 pm
Use isnull around each column: isnull(columnname,'')
October 30, 2008 at 2:14 pm
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....
October 30, 2008 at 2:04 pm
No, you can't define PK/FK relationships between tables in different databases.
October 30, 2008 at 1:53 pm
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 ''' +...
October 30, 2008 at 1:09 pm
Jack beat me to it, but you can also learn more about the patindex function in BOL (Books On-Line).
October 30, 2008 at 12:53 pm
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....
October 30, 2008 at 10:32 am
Also, I assume that ptEncounterEncounterDetailTemp has the same structure as ptEncounterEncounterDetail?
October 30, 2008 at 10:16 am
Just one thing missing, what should the expected results be based on the test data. Need something to check against.
October 30, 2008 at 10:10 am
new coder (10/30/2008)
1-Cell number
2-Home number
3-Work number
For...
October 30, 2008 at 10:04 am
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...
October 30, 2008 at 9:37 am
Viewing 15 posts - 23,971 through 23,985 (of 26,490 total)