current server & database

How to get CURRENT server and database name in MSSQL Server Option for NF? Thanks.

No easy way, unfortunately, without creating a linked object. Create a SQL view in your database:


CREATE VIEW [ServerAndDatabase] AS
SELECT CAST(@@SERVERNAME AS NVARCHAR(128)) AS [Server Name], [Database Name]
FROM Session
WHERE [My Session] = 1

Create a C/SIDE table with the same table and field names (both Text128), with DataPerCompany = No. Save the table and you can use its single record to obtain the server and database.