Me playing with Visual Studio 2005
SQLExpress:
1. if you want to see it under server explorer you need to explicitly state the name of the instance to “.\SQLExpress”.
2. Debugging a function under SQL Express is off by default, to enable it right click the connection name under the Data Connections in the Server Explorer and choose 'Allow SQL/CLR Debugging'.
Comments
- Anonymous
June 30, 2004
hi
setting the name of the instance to ".SQLEXPRESS" during Setup does not work
i always get this message:
"The instance name specified is not valid. To proceed, provide an instance name that complies with instance naming guidelines. For more information, see Instance Name, in SQL Server Books Online."
Can you pls help me?
Is a Query Analyer like in SQL2k (developer edition) included? - Anonymous
June 30, 2004
Hi,
the name SQLExpress is the default one, I didn't change anything in the installation.
I don't know of any Query Analyzer included, I use VS for everything. - Anonymous
June 30, 2004
Yosi,
then where did you enter ".SQLEXPRESS" to enable viewing the database in VS? - Anonymous
June 30, 2004
In the server explorer pane.
Data Connection -> Add.... - Anonymous
June 30, 2004
Thanks Yosi
it's working :)
now i can play with yukon ;)