|
 |
| |
| 創(chuàng)建用戶名時(shí)出錯(cuò)，請(qǐng)確認(rèn)服務(wù)器是否是空閑狀態(tài) |
1.點(diǎn)擊開(kāi)始=》所有程序=》Microsoft SQL Server=》查詢分析器=》選擇SQL Server身份驗(yàn)證，如果在裝數(shù)據(jù)庫(kù)沒(méi)有設(shè)置用戶及密碼時(shí)，登錄名默認(rèn)sa，密碼為空，點(diǎn)擊確定，把以下的腳本復(fù)制進(jìn)去，然后按F5或 者是點(diǎn)擊菜單欄上的小綠色箭頭按鈕，下面提示“命令已成功完成”就OK了。
2.輸入
use msdb
go
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Jxc_Account]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Jxc_Account]
GO
CREATE TABLE [dbo].[Jxc_Account] (
[AccountName] [char] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ServerName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[SQLPath] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DBName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DBSource] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[UserName] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DBPassword] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[OldPath] [char] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO |
|
|
