Board index » delphi » SQL Server version running on NT Server

Vinod Panicker

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

SQL Server version running on NT Server

Hello everyone,

I am writing a MIDAS Briefcase app. with SQL Server 7 as the backend which
would be on the server if the user connects to the server.

I need to know if the users is connected to the network, is SQL Server 7
running.  The server has SQL Server 6.5 and SQL Server 7 on it and either of
them may be running at a given point of time.  Ofcourse, it in ensured that
no one is using the version currently running on the server before switching
to the other SQL version.  The clients wants both SQL version on the server.

Any help on the above would be more than welcome.

Thanks and regards,
Vinod

 
Mike Wals

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server version running on NT Server


Vinod,

Try the sp_server_info stored proc. (Attribute 2 is version)

Mike Walsh

Quote
"Vinod Panicker" <vinod_panic...@hotmail.com> wrote in message

news:3959a018@dnews...
Quote
> Hello everyone,

> I am writing a MIDAS Briefcase app. with SQL Server 7 as the backend which
> would be on the server if the user connects to the server.

> I need to know if the users is connected to the network, is SQL Server 7
> running.  The server has SQL Server 6.5 and SQL Server 7 on it and either
of
> them may be running at a given point of time.  Ofcourse, it in ensured
that
> no one is using the version currently running on the server before
switching
> to the other SQL version.  The clients wants both SQL version on the
server.

> Any help on the above would be more than welcome.

> Thanks and regards,
> Vinod

Mohame

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server version running on NT Server


Select SUBSTRING(@@version,23,4) As VersionSql

Quote
Vinod Panicker <vinod_panic...@hotmail.com> wrote in message

news:3959a018@dnews...
Quote
> Hello everyone,

> I am writing a MIDAS Briefcase app. with SQL Server 7 as the backend which
> would be on the server if the user connects to the server.

> I need to know if the users is connected to the network, is SQL Server 7
> running.  The server has SQL Server 6.5 and SQL Server 7 on it and either
of
> them may be running at a given point of time.  Ofcourse, it in ensured
that
> no one is using the version currently running on the server before
switching
> to the other SQL version.  The clients wants both SQL version on the
server.

> Any help on the above would be more than welcome.

> Thanks and regards,
> Vinod

Other Threads

1. Which bde version to use on ALPHA Server running WIN NT server 4.0

2. How do I connect to a remote SQL server running SQL Server 7

3. Running IB Server Manager on NT 3.51 Server

4. Deploying Application to NT running Sql Server

5. Microsoft NT Terminal server (SQL server 7)

6. Delphi applications on Microsoft NT Terminal server (with SQL server DB)

7. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

8. Moving a GDB from a server running IB7 back to a server running IB6

9. SQL Server 6.5 access via SQL Links as NT Service

10. who I get a actual sql limk for MS SQL server for version 7