string[] myExecuteQuerys = {"create database photo","use photo if not exists (select * from dbo.sysusers where name = N'guest' and hasdbaccess = 1) EXEC sp_grantdbaccess N'guest'",
"use photo CREATE TABLE [dbo].[Album_Pic] ( [PhotoID] [bigint] NULL , [AlbumID] [bigint] NULL ) ON [PRIMARY] ",
"use photo CREATE TABLE [dbo].[Albums] ( [ID] [bigint] IDENTITY (10000001, 1) NOT NULL , [AlbumName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] ",
"use photo CREATE TABLE [dbo].[Photos] ([ID] [bigint] IDENTITY (1000000001, 1) NOT NULL ,[imgurl] [varchar] (5000) COLLATE Chinese_PRC_CI_AS NULL ,[title] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] "
};
foreach (string myExecuteQuery in myExecuteQuerys)
{
SqlConnection mySqlConnection = new SqlConnection("server=localhost;user id=sa;password=315213;Trusted_Connection=yes;");
SqlCommand myCommand = new SqlCommand(myExecuteQuery, mySqlConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
以上代码创建的数据库(sql server 2000),用户dbo的登录名sa丢失了
请高手指点
"use photo CREATE TABLE [dbo].[Album_Pic] ( [PhotoID] [bigint] NULL , [AlbumID] [bigint] NULL ) ON [PRIMARY] ",
"use photo CREATE TABLE [dbo].[Albums] ( [ID] [bigint] IDENTITY (10000001, 1) NOT NULL , [AlbumName] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] ",
"use photo CREATE TABLE [dbo].[Photos] ([ID] [bigint] IDENTITY (1000000001, 1) NOT NULL ,[imgurl] [varchar] (5000) COLLATE Chinese_PRC_CI_AS NULL ,[title] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] "
};
foreach (string myExecuteQuery in myExecuteQuerys)
{
SqlConnection mySqlConnection = new SqlConnection("server=localhost;user id=sa;password=315213;Trusted_Connection=yes;");
SqlCommand myCommand = new SqlCommand(myExecuteQuery, mySqlConnection);
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
mySqlConnection.Close();
}
以上代码创建的数据库(sql server 2000),用户dbo的登录名sa丢失了
请高手指点
if not exists (select * from dbo.sysusers where name = N'sa')
EXEC sp_grantdbaccess N'sa', N'sa'
再加上
GRANT REFERENCES , SELECT , UPDATE , INSERT , DELETE ON [dbo].[你的表名] TO [sa]不过用户不要使用SA比较好吧?