Hi all,
Did you notice that in Microsoft SQL Server Management Studio, when you run a PRINT command, the username and the server name is also printed as a seperate line just before the desired printing result?
For example, if you run the below sql statement in a query window in management studio,
print @@Version
The result displayed in the results pane is as follows:
kodyaz(eralper):
Microsoft SQL Server code name "Katmai" (CTP) - 10.0.1075.23 (Intel X86)
Nov 8 2007 14:16:26
Copyright (c) 1988-2007 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
where "kodyaz" is the SQL Server instance name and the "eralper" is the sql server user account I'm using for the connection.
In the SQL Server Management Studio Options windows which you can open by following Window then Options in the menues of Management Studio, there is a section named "Query Results"
Query Sections results has a sub item SQL Server and it also has another sub-item titled Multiserver Results.
This "Multiserver Results" selection will display :
Add login name to the results
Add server name to the results
Merge results
options. Although I configured the first two "Add login name to the results" and "Add server name to the results" to "False" and re-opened the SQL Server Management Studio, I could not see any difference or affect of these settings as I thought to have.
These configuration settings seems to have no effect on the changed behaviour of PRINT command.
Still looking for a solution,
Thanks