Post reply

In which table i cant find this ??

  • April 14, 2008 at 8:05 am

    #205702

    Hi,

    will u plz tell me in which table i can find this in sql 2000

    select * from sys.dm_exec_sessions

    bcuause in 2000 this table is not exist with this name and i cant find similar table for this .will u plz tell me in which table i can find this

  • April 14, 2008 at 8:19 am

    #802090

    Hi,

    First and foremost this is not a table, it is a dynamic management view or DMV. Secondly, DMVs are not available in SQL 2000. DMVs were implemented in SQL 2005.

    Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance. They also can come in database-scoped flavors as well.

    If you are interested in viewing session-specific information for SQL 2000 you should take this to a SQL 2000 forum. You would probably get a better result there.

    Sorry i could not be of more assistance.

    Brian

    Think great, be great!

  • April 14, 2008 at 8:22 am

    #802095

    Since it is unclear from your posting what are you looking for, the short answer is: master.dbo.sysprocesses

    Management views appeared in SQL 2005 and were not arounf in SQL 2000.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply