Mayer, Stefan wrote:
> Super!
>
> Und wie lege ich eine Datenbank an?

CREATE DATABASE [testdb]  ON (NAME = N'testdb', FILENAME =
N'C:\temp\testdb_Data.MDF' , SIZE = 31, FILEGROWTH = 10%) LOG ON (NAME =
N'testdb_Log', FILENAME = N'C:\temp\testdb_Log.LDF' , SIZE = 2, FILEGROWTH =
10%)
 COLLATE Latin1_General_CI_AS

-- und optional:
exec sp_dboption N'testdb', N'autoclose', N'false'
GO

exec sp_dboption N'testdb', N'bulkcopy', N'false'
GO

exec sp_dboption N'testdb', N'trunc. log', N'true'
GO

exec sp_dboption N'testdb', N'torn page detection', N'true'
GO

exec sp_dboption N'testdb', N'read only', N'false'
GO

exec sp_dboption N'testdb', N'dbo use', N'false'
GO

exec sp_dboption N'testdb', N'single', N'false'
GO

exec sp_dboption N'testdb', N'autoshrink', N'false'
GO

exec sp_dboption N'testdb', N'ANSI null default', N'false'
GO

exec sp_dboption N'testdb', N'recursive triggers', N'false'
GO

exec sp_dboption N'testdb', N'ANSI nulls', N'false'
GO

exec sp_dboption N'testdb', N'concat null yields null', N'false'
GO

exec sp_dboption N'testdb', N'cursor close on commit', N'false'
GO


Gruss

Frank

_______________________________________________
Database.asp mailing list
[EMAIL PROTECTED]
http://www.glengamoi.com/mailman/listinfo/database.asp

Antwort per Email an