Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Numbers table

Author  Topic 

nduggan23
Starting Member

42 Posts

Posted - 2008-02-11 : 14:00:34
Hi all,

a while back i posted about a script i was working on and was told that a Numbers table would help me with my problem. that was grand it did. but i found a script that created in a numbers table in every time a new database was added. this is now causing me issues. i cant find where i got the script or how to disable it. it added something to the master schema i think that when a new database is created it automatically creates a numbers table in it... anyone be able to help me with this please???

N

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2008-02-11 : 14:12:16
Check in the Model database.
Go to Top of Page

nduggan23
Starting Member

42 Posts

Posted - 2008-02-12 : 09:05:34
quote:
Originally posted by Van

Check in the Model database.



Cheers. found it. :)
Go to Top of Page
   

- Advertisement -