Viewing 3 posts - 1 through 3 (of 3 total)
Great article. A few points:
1. remake your idempotent statements to "if not exist create, then alter", rather than drop/create.
Example:
if object_id(N'[schema].[sp_proc]',N'P') is null
...
December 21, 2016 at 6:01 am
Found unicode characters in the script, otherwise was fine.
Added FILLFACTOR to the script - important!
1. added declaration at the top:
declare @fillfactor int
2.Added the assignation...
August 1, 2010 at 6:00 am
This was an elegant solution to what has been a plague on our DBAs during migrations from old systems to new - particularly with COTS databases that routinely use character...
July 20, 2010 at 9:15 am
Viewing 3 posts - 1 through 3 (of 3 total)