I can only seem to
(1) connect to a named instance (./namedinstancename), which I do not use.
(2) be able to attach a new mdf, rather than connect to an existing db
I know that the express edition is restricted to local dbs, but is it also restricted to named instances?
ThanksCan you post the steps you used to find this. I can't seem to reproduce the problem.|||If the SQL2k instance is a default instance then you can connect just by using . or (local) or <<machinename>>. There is no need to tell SSMS that it is connecting to a SQL2k instance it will detect automatically.
If the instance is named then you need one of the above and then the instance name.
-Euan
Please reply only to the newsgroup/forum so that others can benefit. When posting,please state the version of SQL Server being used and the error number/exact error message text received, if any.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Can you kindly send the steps to create a db and table in sql2000?
No comments:
Post a Comment