OT Question: SQL2005 Management Tools?

Hi;

Although this question is unrelated to Linq, but since everyone here uses SQL2005, I thought it's a good place to ask.

I need a light weight management tool for creating database, tables, fields, indexes and FK. A tool that is easy to use, to view fields and quick to add fields one after another. The SQL Management Studio is great, but I like to have something on the side for quick changes.

I looked around and the few that I found are bigger and more cumbersome than SQL Studio.
Any recommendations?

Thank you in advance!

Hi Ben,

You have a number of options.

Server Explorer within Visual Studio can manage your database - quick and easy.

SQL Server Management Studio Express (http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en). Cut down version aimed at SQL Server Express, this could be your best bet.

SQLCMD - Do everything via the command line

I've heard that Joe Albahari's LinqPad can be used to manage databases and is very lightweight. But I think it can only replace SSMS if you can write the SQL

http://www.albahari.com/linqpad.html

Also, he has done a query express tool http://www.albahari.com/queryexpress.html

Hope this helps.

Ben

|||>>SQL Server Management Studio Express (http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en). Cut down version aimed at SQL Server Express, this could be your best bet.<<

Hi Ben;
I tried to install the express edition, but it tells me that I already have the full blown version installed and the express can not be installed.
Do you known of any other third party products that are light weight.

Thanks for your reply!

orphans user

I restored db from sql2000 to sql2005, i did fix the all
orphans users except SYS and DBO. How can i drop them from my db?
thanks
Read about sp_change_users_login in Books Online. Also Google for sp_help_revlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Viktor" <serguienkov@.hotmail.com> wrote in message news:OmbaV67yHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I restored db from sql2000 to sql2005, i did fix the all
> orphans users except SYS and DBO. How can i drop them from my db?
> thanks
>

orphans user

I restored db from sql2000 to sql2005, i did fix the all
orphans users except SYS and DBO. How can i drop them from my db?
thanksRead about sp_change_users_login in Books Online. Also Google for sp_help_revlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Viktor" <serguienkov@.hotmail.com> wrote in message news:OmbaV67yHHA.1188@.TK2MSFTNGP04.phx.gbl...
>I restored db from sql2000 to sql2005, i did fix the all
> orphans users except SYS and DBO. How can i drop them from my db?
> thanks
>

orphans user

I restored db from sql2000 to sql2005, i did fix the all
orphans users except SYS and DBO. How can i drop them from my db?
thanksRead about sp_change_users_login in Books Online. Also Google for sp_help_re
vlogin.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Viktor" <serguienkov@.hotmail.com> wrote in message news:OmbaV67yHHA.1188@.TK2MSFTNGP04.phx.g
bl...
>I restored db from sql2000 to sql2005, i did fix the all
> orphans users except SYS and DBO. How can i drop them from my db?
> thanks
>