【文章內(nèi)容簡介】 ge exec sp_addlogin N39。MSProjectServerUser000039。, null, @logindb, @loginlangENDGO/****** Object: Login MSProjectUser Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。MSProjectUser39。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。master39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。MSProjectUser39。, null, @logindb, @loginlangENDGO/****** Object: Login MSProjectUser0000 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。MSProjectUser000039。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。ProjectServer000039。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。MSProjectUser000039。, null, @logindb, @loginlangENDGO/****** Object: Login student1 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。student139。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。TMS39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。student139。, null, @logindb, @loginlangENDGO/****** Object: Login student2 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。student239。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。TMS39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。student239。, null, @logindb, @loginlangENDGO/****** Object: Login teacher1 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。teacher139。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。TMS39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。teacher139。, null, @logindb, @loginlangENDGO/****** Object: Login teacher2 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。teacher239。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。TMS39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。teacher239。, null, @logindb, @loginlangENDGO/****** Object: Login ea1 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。ea139。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。TMS39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。ea139。, null, @logindb, @loginlangENDGO/****** Object: Login ea2 Script Date: 2003115 5:39:06 ******/if not exists (select * from where loginname = N39。ea239。)BEGIN declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N39。TMS39。, @loginlang = N39。簡體中文39。 if @logindb is null or not exists (select * from where name = @logindb) select @logindb = N39。master39。 if @loginlang is null or (not exists (select * from where name = @loginlang) and @loginlang N39。us_english39。) select @loginlang = @@language exec sp_addlogin N39。ea239。, null, @logindb, @loginlangENDGO/****** Object: Login lijia Script Date: 2003115 5:39:06 ******/exec sp_addsrvrolemember N39。lijia39。, sysadminGO/****** Object: User dbo Script Date: 2003115 5:39:06 ******//****** Object: User teacher1 Script Date: 2003115 5:39:06 ******/if not exists (select * from where name = N39。teacher139。 and uid 16382) EXEC sp_grantdbaccess N39。teacher139。, N39。teacher139。GO/****** Object: User student1 Script Date: 2003115 5:39:07 ******/if not exists (select * from where name = N