| If you have been playing with SQL Server Management Studio 2008 and are modifying tables in the designer, you may run into this error:
Save |
 |
| If you need to drop database connections for a specific database, go read on.. This has been tested for Microsoft SQL Server 2005 and Microsoft SQL Server 2008. |
 |
This is a quite simple task ..
Assuming you have an MDF file called cxnMassImport.mdf and you want to attach it using osql.exe.
Open a CMD
Type:
osql.exe -E -S .\SQLExpress
How to Change the Default Login Authentication Mode to SQL
short description:
use SECURITYMODE=SQL as command line setup parameter when installing SQL Server
or
change one of the following registry keys:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\ Instance Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated security. (Integrated is the default setup for the SQL Server 2000 Data Engine.)
for more refer to article MS Q285097
Tried to start Microsoft SQL Server Enterprise Manager and got stuck at the error message General OLE Error 16386:
try this, maybe this solves the issue..
a. Stop all SQL Server services (MSSQLServer, SQLServerAgent, MSSEARCH)
b. Open command prompt and go to the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn directory
c. Unregister the following .dll files (Ex. regsvr32 /u dtsui.dll): dtsui.dll,sqlns.dll, sqldmo.dll, sqllex.dll, sqlmmc.dll
d. Copy and paste the .dll files from a CD (under x86\Binn directory) to the Program Files\Microsoft SQL Server\80\Tools\Binn
e. Register the .dll files (Ex. regsvr32 sqldmo.dll)
Loading...