plz write the code i should write in query analyzer box to uplode
my database(db) in my server(h_server)
and is it neccessary to uplode log file or not
,or guide me with intruducing a sitewhat xactly are you trying to do ? just load up query analyzer to test some queries ? its in the menu under microsoft sql server under your programs menu. or you can open it from tools - > query analyzer from sql server xplorer.
hth|||i understand what you ae saying but i dont know who i replace suitable elements in this code
CREATE DATABASE [co] ON (NAME = N'co_Data', FILENAME = N'e:\sqlserver 2000\MSSQL\data\co_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'co_Log', FILENAME = N'e:\sqlserver 2000\MSSQL\data\co_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
exec sp_dboption N'co', N'autoclose', N'true'
GO
exec sp_dboption N'co', N'bulkcopy', N'false'
GO
exec sp_dboption N'co', N'trunc. log', N'true'
GO
exec sp_dboption N'co', N'torn page detection', N'true'
GO
exec sp_dboption N'co', N'read only', N'false'
GO
exec sp_dboption N'co', N'dbo use', N'false'
GO
exec sp_dboption N'co', N'single', N'false'
GO
exec sp_dboption N'co', N'autoshrink', N'true'
GO
exec sp_dboption N'co', N'ANSI null default', N'false'
GO
exec sp_dboption N'co', N'recursive triggers', N'false'
GO
exec sp_dboption N'co', N'ANSI nulls', N'false'
GO
exec sp_dboption N'co', N'concat null yields null', N'false'
GO
exec sp_dboption N'co', N'cursor close on commit', N'false'
GO
exec sp_dboption N'co', N'default to local cursor', N'false'
GO
exec sp_dboption N'co', N'quoted identifier', N'false'
GO
exec sp_dboption N'co', N'ANSI warnings', N'false'
GO
exec sp_dboption N'co', N'auto create statistics', N'true'
GO
exec sp_dboption N'co', N'auto update statistics', N'true'
GO
use [co]
GO
CREATE TABLE [dbo].[users] (
[u_id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[u_username] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_password] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_joindate] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_prof] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_fname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_lname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_coname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_location] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_nation] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_website] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[u_account] [float] NULL
) ON [PRIMARY]
GO
No comments:
Post a Comment