Double parentheses when scripting defaults

FAQ

Profile

Double parentheses when scripting defaults

Database Help (Home) -> Programming

Next: db2 restoration

Author

Message

bg1987

External

Since: Dec 21, 2009
Posts: 1

(Msg. 1) Posted: Mon Dec 21, 2009 2:27 am Post subject: Double parentheses when scripting defaults Archived from groups: microsoft>public>sqlserver>programming (more info?)

I have a monitor that compares schemas of tables and reports any changes between servers, I've noticed, there are some servers that all their default definitions have double parentheses, after trying to change it back to "normal" they come back, also when creating new tables (using either management studio or t-sql) the double parentheses come back, this happens server wide, regardless of database. This only happens on specific servers, leading me to believe it might be some server settings (or some bug related to one). Anyone knows the cause of this? all these tables keep appearing on my monitor and flooding my email with so-called "differences" TIA, Benny. >> Stay informed about: Double parentheses when scripting defaults

Display posts from previous:

Related Topics:

Column Defaults Parentheses creating differently between S.. - I'm seeing something a little strange. Scenario: SQL 2000 SP4 Standard and SQL 2005 SP1 Standard, both running on Windows 2003 R2 SP1. I create a table with an integer column that has a default of 0 (zero). When I script out the table from a SQL 2000....

How exec a sproc with parms with defaults - here are my parameters: CREATE Procedure dbo.ESIMonthly ( @ProcessDate DateTime = Null, @SubsidyPerChild SmallMoney = 100.00, @Rerun bit = 0, @Payments int OUTPUT, @TotalPaid Money OUTPUT ) since first 3 parms have defaults how do I execute this..

temp tables with UDF defaults - how do you get a temp table to use a udf in your db? I tried putting the databasename in front of dbo but it complained about it. Does the function need to be created in tempdb too? Create function mydate() returns datetime as begin declare @d..

scripting the records - hey all, is there any easy way to create a script for the records in a table automatically without having to type in the insert statements for each record? thanks, rodchar

Scripting roles with sproc? - In SQL Server 2005, I'm creating a database locally and will upload to a production server at some point. The user roles associated to each sproc locally and on production will be the same. Is there an easy way for me to script out the roles that go..

	Database Help (Home) -> Programming	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum