"Jay" <jayesh131@hotmail.com> wrote in message
news:fb0ff48e.0412052154.269c3168@posting.google.com...
> IF NOT EXISTS(SELECT [Name] FROM sysobjects WHERE [Name] =
> 'dfltStatus' AND type = 'D')
> CREATE DEFAULT dfltStatus AS 1
>
>
> I get the following error msg:
> Incorrect syntax near the keyword 'DEFAULT'.
>
> Note, the statement "CREATE DEFAULT dfltStatus AS 1" and the SQL
> statement
> "SELECT [Name] FROM sysobjects WHERE [Name] = 'dfltStatus' AND type =
> 'D'" work fine on their own.
>
>
> Thanks.

"jack.lee" <lee_j@21cn.com> wrote in message
news:%23i%23kp012EHA.1408@TK2MSFTNGP10.phx.gbl...
> Hi Jay,
> You have to create default as the following code:
> IF NOT EXISTS(SELECT [Name] FROM sysobjects WHERE [Name] =
> 'dfltStatus' AND type = 'D')
> Begin
> DROP DEFAULT dfltStatus
> End
> CREATE DEFAULT dfltStatus AS 1
>
> Thanks!
> Jack
>
> "Jay" <jayesh131@hotmail.com> ????
> news:fb0ff48e.0412052154.269c3168@posting.google.com...
>> IF NOT EXISTS(SELECT [Name] FROM sysobjects WHERE [Name] =
>> 'dfltStatus' AND type = 'D')
>> CREATE DEFAULT dfltStatus AS 1
>>
>>
>> I get the following error msg:
>> Incorrect syntax near the keyword 'DEFAULT'.
>>
>> Note, the statement "CREATE DEFAULT dfltStatus AS 1" and the SQL
>> statement
>> "SELECT [Name] FROM sysobjects WHERE [Name] = 'dfltStatus' AND type =
>> 'D'" work fine on their own.
>>
>>
>> Thanks.
>
>

> IF NOT EXISTS(SELECT [Name] FROM sysobjects WHERE [Name] =
> 'dfltStatus' AND type = 'D')
> CREATE DEFAULT dfltStatus AS 1
>
>
> I get the following error msg:
> Incorrect syntax near the keyword 'DEFAULT'.
>
> Note, the statement "CREATE DEFAULT dfltStatus AS 1" and the SQL
> statement
> "SELECT [Name] FROM sysobjects WHERE [Name] = 'dfltStatus' AND type =
> 'D'" work fine on their own.
>
>
> Thanks.