Database Change Management
Database Change Management
Home | Profile | Register | Active Topics | Active Polls | Members | Private Messages | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Support
 DB Ghost Support Forum
 Script DB difference
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mikas


7 Posts

Posted - 11/04/2009 :  16:16:45  Show Profile Send Mikas a Private Message  Reply with Quote
Any idea why when serveral months ago I scripted my Tables and got a default of (0) and today I get ((0)) ???

This will cause new compares to reset stuff that is not necessary.


[BATCH_NUMBER] [decimal] (6,0) NOT NULL CONSTRAINT [DF__APFAB__BATCH_NUMBER] DEFAULT (0),

[BATCH_NUMBER] [decimal] (6,0) NOT NULL CONSTRAINT [DF__APFAB__BATCH_NUMBER] DEFAULT ((0)),

Mark Baekdal



86 Posts

Posted - 11/04/2009 :  23:27:03  Show Profile  Visit Mark Baekdal's Homepage Send Mark Baekdal a Private Message  Reply with Quote
The extra brackets are produced by SQL2005+. At a guess I would say that the old script was produced when scripting from a SQL2000 or less database and the new script is produced by a SQL2005 database. I guess if you're comparing scripts then you'll see a difference - if however you're comparing databases using DB Ghost there'll not be a difference.

regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
Take control of your SQL Server code.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  New Poll New Poll
 Reply to Topic
 Printer Friendly
Jump To:
Database Change Management © Copyright 2005 Innovartis Ltd. Go To Top Of Page
Snitz Forums 2000
RSS Feed 1 RSS Feed 2
Powered by ForumCo 2000-2008
TOS - AUP - URA