Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.8K
2 Posted Topics
You can also do a full DB backup from the source server then copy/restore the backup file on the new server. This leaves your original source DB intact. You may need to use the MOVE option if you want the data/log files in different drives/paths.
The function call below converts a YYMMDD numeric value to a datetime data type. The second parameter adds leading zeros in case the date has less than 6 digits (ex: 80910 = Sep 10, 2008) then trims it back down to the 6 right-most digits. declare @i int set @i …
The End.