[dbo].[collectserver]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:10 AM Wednesday, March 07, 2007
Last Modified	11:09:36 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
server_name	varchar(255)	255
server_addr	int	4
server_u_id	varchar(32)	32
server_u_pswd	varchar(64)	64
db_server_name	varchar(255)	255
db_id	varchar(32)	32
db_pswd	varchar(64)	64
server_type	varchar(32)	32

Name	Columns
baseidx_collectserver	server_addr

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[collectserver]
(
[server_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[server_addr] [int] NOT NULL,
[server_u_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[server_u_pswd] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_server_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[db_id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_pswd] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[server_type] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_collectserver] ON [dbo].[collectserver] ([server_addr]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[collectserver] TO [uniadmin]
GRANT INSERT ON  [dbo].[collectserver] TO [uniadmin]
GRANT DELETE ON  [dbo].[collectserver] TO [uniadmin]
GRANT UPDATE ON  [dbo].[collectserver] TO [uniadmin]
GRANT SELECT ON  [dbo].[collectserver] TO [uniuser]
GO