hallo,
ich bin absolut neu und habe noch nicht viel ahnung...
ich möchte anhand von 2 sql-scripts (.sql) eine datenbank erstellen (windows web server 2008).
die scripts sehen so aus:
=================== create.sql ================================
USE [master]
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'gsmlanka')
DROP DATABASE [gsmlanka]
GO
CREATE DATABASE [gsmlanka]
GO
===========================================================
================= build.sql ====================================
PRINT 'CREATING User dbo'
if not exists (select * from dbo.sysusers where name = N'dbo' and uid < 16382)
EXEC sp_grantdbaccess N'sa', N'dbo'
GO
PRINT 'CREATING TABLE Users'
CREATE TABLE [Users] (
[UserID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Pass_word] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[F_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[L_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Bday] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Gender] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Country] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Zip] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Address] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Sec_Question] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Answer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Priviladge] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Posts] [int] NULL ,
[JoinedDate] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ImageURL] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
[UserID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
=========================================================
wie bzw wo wende ich die scrips an?
danke