Prev: DB1 filegroup backups used to refresh same filegroup on DB2 ?
Next: Cannot connect to Database Engine
From: Sylvain Lafontaine on 17 May 2010 16:39
I don't know for sure for SSMS 2005 but for SSMS 2008, make sure that you
are looking under the Scripting node instead of the Commands node when
expanding the SQL Server Object Explorer properties.

It's the third option under the sub-node "Table and view options" (still for
SSMS 2008).

Also, you can install and use SSMS 2008 for working against SQL-Server 2005
databases.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"Bodo" <1> wrote in message news:Ohb9i2e9KHA.3880(a)TK2MSFTNGP04.phx.gbl...
>
> "Sylvain Lafontaine" <sylvainlafontaine2009(a)yahoo.ca> schrieb im
> Newsbeitrag news:eFrcWte9KHA.1872(a)TK2MSFTNGP02.phx.gbl...
>>
>>> Unfortunately SQL Server Management Studio "supports" you with collation
>>> by
>>> adding the db default collation with each Create table statement that
>>> you can produce
>>> by right klick on a table ... script table to...
>>> e.g:
>>> CREATE TABLE [dbo].[TB_ADRESSBERICHT_BETRIEB](
>>>
>>> [SATZART] [varchar](1) COLLATE Latin1_General_CI_AS NOT NULL,
>>>
>>> [KALENDERJAHR] [int] NOT NULL,
>>>
>>> [KALENDERMONAT] [tinyint] NOT NULL,
>>>
>>> ...
>>>
>>> So there has been a few scripts in the past with explicit Collate
>>> specification that I give to my client.
>>> Later on I always removed that clause from each create statement.
>>> Now the production database defintion is consistent to my development
>>> system.
>>>
>>> Again many thanks to both of you!
>>>
>>> Best regards
>>> Bodo
>>
>> You can deactivate the option of scripting the collations: Tools |
>> Options | SQL Server Object Explorer | Scripting | Include collation ->
>> set to False.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Windows Live Platform
>> Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
>> Independent consultant and remote programming for Access and SQL-Server
>> (French)
>>
>>
>>
> Thanks Sylvain,
> I thought there must be such option in SSMS, however I can't find this
> option in Tools-Options-SQL Server Object Explorer.
> I work with MS SSMS 9.0 (2005).
>
> Thanks
> Bodo
>


From: Erland Sommarskog on 17 May 2010 17:15
Bodo (1) writes:
> I thought there must be such option in SSMS, however I can't find this
> option in Tools-Options-SQL Server Object Explorer.

They are in the place that Sylvain described. However, the general
Scripting options were added in Service Pack 2 of SQL 2005, so if you
have failed to install any service pack, you don't have this option.

I strongly recommend that you download and install the latest Service
Pack, which is SP3 for SQL 2005.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: Bodo on 17 May 2010 17:46
Thanks a million to all of you
- I'm on my way to SQL 2005 SP3

Bodo


First  |  Prev  | 
Pages: 1 2 3
Prev: DB1 filegroup backups used to refresh same filegroup on DB2 ?
Next: Cannot connect to Database Engine