RomanH
27th August 2007 10:52 UTC

Check database(MSSQL)
Hello, All.
How I can check exisiting Database in MSSQL-server.
I use MUI and isql.exe.

govmust
28th August 2007 12:59 UTC

Could you be more specific?
If your looking for istaled instances,
read it from registry key HKLM\Software\Microsoft\Microsoft SQL Server\InstalledInstances
If its something else then I don't understand you.

lushdog
28th August 2007 14:21 UTC

Change to SSEUtil.exe, it works with SQL 2000 and SQL 2005 as well as MSDE 2000 and SQL Express 2005.

Not sure if it is legal to redistribute yet though.

ExecWait '"$INSTDIR\SSEUtil.exe" -l' <- L not 1 or i

sgiusto
30th August 2007 22:18 UTC

If you want to know if a sql device exist use a statement like this:
if exists (select name from sysdatabases where name='mydevice') <do what you need>