SQL SERVER常用

NET STOP mssql$sqlexpress

NET START mssql$sqlexpress

sc config SQLBrowser Start= auto

NET START SQLBrowser

osql.exe -E -S .\SQLEXPRESS

osql.exe -U USER -P PWD -S .\SQLEXPRESS

osql.exe -E -S .\SQLEXPRESS -i "C:\\SQL.TXT"

EXEC sp_password NULL, 'BSD2010', 'sa'

ALTER LOGIN sa ENABLE\

select name from sysdatabases 

select filename from sysfiles where fileid = 1

select filename from sysfiles where fileid = 2

EXEC sp_detach_db @dbname=N'DBNAME'

EXEC sp_atttach_db @dbname=N'DBNAME',@filename1=N'',@filename2=N''

EXEC sp_attach_single_file_db @dbname=N'DBNAME',@physname=N''