Administration

• Topics

  Started by

  Posts

  Last post

• Tracking Blocking

  What is the best practice to track blocking on a particular database? I know where my issues are a…

  JeffE

  2 replies

  22 years ago

  By: JeffE

• default date format

  this has got to be annoyingly simple but how do you change the default date format? select getdate(…

  lotusnotes

  19 replies

  22 years ago

  By: Roman1

• RE: SQL licensing mode

  Hi, Is it possible to change SQL licensing mode from Per Seat to Per processor after the installati…

  XuJohn

  2 replies

  22 years ago

  By: Steve Jones - SSC Editor

• Patch Management Mailing List

  Hi there, just became aware of this mail and i though I'd drop it in here quote: Greetings, PatchM…

  Frank Kalis

  1 replies

  22 years ago

  By: noeld

• how to shrink logfile in sql 6.5

  Hi all, How to shrink log file in sql 6.5? Please advise. Thanks! Robert

  Robert Lu

  3 replies

  22 years ago

  By: Robert Lu

• ODBC ERROR

  PLEASE HELP!!!!! For some reason the logins on our sql server does not disconnect after we close ou…

  ayisat

  3 replies

  22 years ago

  By: billkamp

• OSQL is performing better then SQL Server Agent

  I have created several jobs on a specific SQL instance on a server running multiple instances. For …

  Leon Bakkers

  2 replies

  22 years ago

  By: cafemar1

• Monitor Activity By Connection

  Is is possible to monitor SQL Server Activity by a connection. We have a user that is running a cli…

  ccundy

  1 replies

  22 years ago

  By: Jeff W

• Job failed with access denied on opening datafile

  Does anyone experience the following, the job running is under my account, I am the local Admin and…

  tyang

  8 replies

  22 years ago

  By: jgroseth

• Stale Logins

  Can someone help....trying to see if their is a way to use T-SQL to monitor all logins that are not…

  jlv1

  5 replies

  22 years ago

  By: Jeff W

• Getting full userlist from SQL.

  Anyone know how to obtain a full userlist from a SQL Database with full permissions. There must be …

  a5972s

  5 replies

  22 years ago

  By: a5972s

• Extra events to log

  Hi I will like some recommendations for events/errors to be added to the event log Failed logins be…

  mngong

  2 replies

  22 years ago

  By: mngong

• UTC date conversion

  Hi all! I am trying to convert a UTC date to local time. The UTC date is stored in the database for…

  TheDiBa

  3 replies

  22 years ago

  By: simon_hyan

• Inverted Dates in DTS ActiveX Step ???

  Hi, Can anyone shed some light on a peculiar situation we are having with some of our DTS packages …

  jima

  1 replies

  22 years ago

  By: jima

• Bulk Loading Logins

  We are needing to load 250-300 users to a database. Is there any way to load the users and passwor…

  eesiii41

  6 replies

  22 years ago

  By: jarretg