Solved

sys.dm_exec_connections equivelant in SQL Server 2000

Posted on 2008-10-22
7
1,874 Views
Last Modified: 2011-04-14
I am trying to write this query in SQL Server 2000, anyone know how to convert it:

SELECT      auth_scheme
  FROM      sys.dm_exec_connections
 WHERE session_id = @@SPID
0
Comment
Question by:computerstreber
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 22780979
select * from syssessions
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 22780982
sorry:

select * from sysprocesses
0
 
LVL 3

Author Comment

by:computerstreber
ID: 22781220
How do I know if Kerberos is being used or not?
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 15

Accepted Solution

by:
MohammedU earned 500 total points
ID: 22782140
In 2000 I believe you have to depend on registry...
in 2005
select auth_scheme from sys.dm_exec_connections where session_id=@@spid
0
 
LVL 3

Author Closing Comment

by:computerstreber
ID: 31508947
I ended up calling MS support and this is exactly what they told me.
0
 

Expert Comment

by:gihrnm
ID: 24223326
MohammedU,
How to check from registry?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24224318
the answer you select is incorrect.
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question