List of server connections

Hello,

I use SQL Server Management Studio Express. When I want to connect to some server the application form offers me several servers that I used to connect to in past. Where can I manage this offer (delete some obsolete servers).

Thanks

hi,

I do think you find it in

C:\Documents and Settings\YourName\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

.. but, if it is, my advice is not to hack it..

regards

Linux user: creating databases

Hi all.
I just installed MSSQL 2005 Express but I can′t find a sql client I can use to create databases.
Do I have to download it or it′s placed somewhere on my HD?
The only tools I see are placed at Start > Programs > Microsoft SQL Serve 2005 > Configuration Tools
Sorry about the dump question. I come from a linux background and everything seems to be different!
Cheers.
The download for the Express Edition does not include a GUI tool for managing the database. We have posted a pre-release version of the free management GUI tool - Management Studio Express Edition on the web for download. You can get it at: http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en.

You can also download the documentation for Express at http://www.microsoft.com/downloads/details.aspx?FamilyID=9697aaaa-ad4b-416e-87a4-a8b154f92787&DisplayLang=en.

Out-of-the-box Express includes a command line tool SQLCMD for working with the installation (creating databases, creating tables, etc.) You can read more about it in the documentation.

Good luck.

Dan|||Hi Dan. Thanks for your quick reply!
In the meanwhile I downloaded the trial version (~900mb, outch!!).
How do I import ddl files into a database (trial version)?
Can I do it using theManagement Studio Express Edition too?
Cheers!
|||You can execute your sql script using SQLCMD.exe (from the command line) or using the Management Studio Express GUI.