Skip to content

SQL Server Consulting

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Consulting”.

Comment (RSS)  |  Trackback

5 Comments

  1. Marco says:
    January 13, 2012 at 10:36 am

    Hi Derek, in sql2000 i can see the sessions connected thru the lan doing “select * from sysprocesses”, now i’m working with a web application, the users are connected thru the internet. I can’t see all the sessions with sysprocesses. What can I do? How can I see them?.

    Reply to this comment
    • Derek Dieter says:
      January 23, 2012 at 10:10 am

      Hi Marco,

      It sounds like a permissions issue, however I wouldn’t want to give the web user access to see the sysprocesses personally. Aside from giving more permissions I don’t think there’s much you can do with SQL 2000 regarding that.

      Derek

      Reply to this comment
  2. Hidayath khan says:
    December 2, 2011 at 3:19 am

    In order to shrink the Tempdev file by avoiding the restart of the production system we can adapt the below method ..but I am just keen how it will affect the performance of the over All Data Base System …
    Will you please give the more detail on it..
    DBCC FREESYSTEMCACHE (‘ALL’)
    DBCC FREEPROCCACHE
    USE [tempdb]
    GO
    DBCC SHRINKFILE (N’tempdev’ , 1000)

    Thanks ..

    Reply to this comment
  3. Alhanoof says:
    August 15, 2011 at 3:52 am

    Hello,
    i was wondering if you provide any classes for teaching ?

    Thanks
    Alhanoof

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!