随笔分类 -  MSSQL

Directory lookup for the file "xxx.mdf" failed with the operating system error 2
摘要：Directorylookupforthefile"xxx.mdf"failedwiththeoperatingsystemerror2(系统找不到指定的文件。).reason：sql2005以后禁用了xp_cmdshell存储过程solution：sp_configure 'show advanc... 阅读全文
posted @ 2015-01-21 12:24 StuJnX6ry 阅读(602) 评论(0) 推荐(0)
MSSQL localdb sa
摘要：CREATE LOGIN [sa] WITH PASSWORD = '888';ALTER LOGIN [sa] ENABLEGOALTER LOGIN [sa] WITH PASSWORD = '888';GO 阅读全文
posted @ 2015-01-20 22:00 StuJnX6ry 阅读(292) 评论(0) 推荐(0)