How to determinate if I have install sp1 of SqlExpress

Hi,
How to determinate if I have install the sp1 of SqlServer 2005 Express?ad
SELECT @.@.Version?
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uC8pZYHfGHA.1276@.TK2MSFTNGP03.phx.gbl...
> Hi,
> How to determinate if I have install the sp1 of SqlServer 2005 Express?
>

How to determinate if I have install sp1 of SqlExpress

Hi,
How to determinate if I have install the sp1 of SqlServer 2005 Express?ad
SELECT @.@.Version?
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uC8pZYHfGHA.1276@.TK2MSFTNGP03.phx.gbl...
> Hi,
> How to determinate if I have install the sp1 of SqlServer 2005 Express?
>sql

How to detect and add exceptions to Firewall programmatically?

I've been successful at installing a customized SQLexpress using setup.exe /settings template.ini.

What I'd like to do now is see if I can progammatically detect a Firewall on the SQLexpress machine and if there is one to add the exceptions for sqlservr and sqlbrowser programmatically so that the user doesn't have to do anything.

Is this possible and how would I do it?

Thanks,

jerry

You'll have to use the Windows Firewall API to do this. There is a topic on adding Program Exceptions here.

Mike

|||

Thanks Mike... that puts me on the right track.

/jerry

How to delete a sqlexpress database from the visual 2005

Hello,

I created a database in my local sqlexpress server, using the 'Create New SQL server database ..." option in the Server Explorer of VS 2005.

How can i delete this database now using VS 2005 ?

it seems that the 'Delete' option, only remove the link in the 'Data Conncetions ' folder.

Thanks and Regards

Denis

To delete a database go to the command line and type the following:

C:\>sqlcmd -S <server_name>\<instance_name>
1> drop database <db_name>
2> go
1>

e.g.

C:\>sqlcmd -S dtjones\sqlexpress
1> drop database deleteme2
2> go
1>

Cheers,
Dan