CODEWITHSUNDEEP
sql-server-2008sql-server-2008r2-express
FullStack-.NetMVC-BizMule-Dev
FullStack-.NetMVC-BizMule-Dev

Reputation: 803

Issue with SQL Server Management Studio

I have installed SQL Server 2008 R2 onto my machine.
Looks my I have problem with my SSMS (SQL Server Management Studio).

For every login it is showing the credential information differently. Please observe the tooltip on below screen shot of different tabs on same SSMS. The user account info is verying always.

For every Windows Authentication Login tooltip is ending with the below user account(fs\c005057(105,128,114,51 etc.....)) Example:
If the below screen shot is not clear, tooltip is showing as below.

TAB1(ToolTip) --c:\SQLSErver\CreateSP1\(fs\c005057(105))
TAB2(ToolTip) --c:\SQLSErver\ExeucuteScriptOfSP1\(fs\c005057(128))
TAB3(ToolTip) --c:\SQLSErver\CreateSP2\(fs\c005057(114))
TAB4(ToolTip) --c:\SQLSErver\ExeucuteScriptOfSP1\(fs\c005057(51))

Problem, what I'm having now is, If I compile the Storedprocedure in Tab1 and If I executing the SP by giving the parameter in Tab2 in same SSMS, the results are totally unexpected. Suspecting this is the issue. I didn't see this kind of credential information with my previous SSMS, So suspecting.

enter image description here

Upvotes: 0

Views: 336

Answers (1)

Aaron Bertrand
Aaron Bertrand

Reputation: 280252

Those are the session_id values. Run the following in any query window:

SELECT @@SPID;

They will match the tooltip. Your unexpected results are caused by a different issue, I guarantee it.

Upvotes: 1

Related Questions