User Defined Defaults & DataTypes

Posted on 2005-05-03
Last Modified: 2012-05-05
I created a database from an SQL export of another database. Both are SQL Server 2000. The issue I have with the new database is that the default values, which are assigned to user defined data types, are not inserting automatically. Why are the defaults which are assigned to the data types, not propagating on inserts?
Question by:paulfryer
    LVL 28

    Accepted Solution

    During the Import/Export, if you selected the first option "Copy tables and views from the source database", then the defaults will not be exported to the destination database.  If you want the defaults to be included, select the third option "Copy objects and data between SQL Server databases".
    LVL 1

    Author Comment

    I did a copy from a SQL script, I did NOT use the import wizard.
    LVL 28

    Expert Comment

    How did you generate the SQL scripts?  Is it through Enterprise Manager--> Generate SQL Scripts?  If so, did you go to the Options tab and selected the Table Scripting Options, specifically the last one, "Script PRIMARY keys, FOREIGN keys, defaults and check constraints"?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now