Administering

• Topics

  Started by

  Posts

  Last post

• SQL - Win File System

  How would i access list of files with modified date in windows directory from SQL Query.

  Tara-1044200

  1 replies

  17 years, 1 months ago

  By: Ken Simmons

• finding old/inactive databases

  I need a way to identify old/used/inactive databases in SQL 2005, what is the best and most reliabl…

  erickopp

  2 replies

  17 years, 1 months ago

  By: Jeff Moden

• What do you miss out on with Compaiblity Level 80 in SQL Server 2005?

  If you set the Compaiblity Level to 80 for a database in SQL Server 2005, what do you miss out on?

  JamesNZ

  6 replies

  17 years, 1 months ago

  By: MMartin1

• Unexpected Locks

  Hello. I'm hoping someone out there can help. I have the following table: CREATE TABLE [dbo].[Table…

  Ned

  2 replies

  17 years, 1 months ago

  By: Ned

• mysql to SQL Server

  Do i need to install any mysql driver to import/export data from mysql databases.

  Tara-1044200

  2 replies

  17 years, 1 months ago

  By: Lynn Pettis

• SQL Account access to multiple servers

  I have a SQL Server A where in it has sql account used for an application. When i try to run a quer…

  Tara-1044200

  2 replies

  17 years, 1 months ago

  By: maechismo_8514

• SP3 bundled with regular microsoft updates

  I'm sure this has been discussed and I missed the posts. Our Systems team installed some Microsoft…

  Indianrock

  6 replies

  17 years, 1 months ago

  By: Lynn Pettis

• Deadlocks CleanCnt

  When looking at deadlock info SPID: 632 ECID: 0 Statement Type: UPDATE Line #: 63 Owner:0x00000000…

  zach_john

  4 replies

  17 years, 1 months ago

  By: zach_john

• Can some tell me if these settying on my server set correctly

  Can some tell me if these settying on my server set correctly Use AWE memory is checked Dynamic mem…

  Krasavita

  1 replies

  17 years, 1 months ago

  By: Jeffrey Williams

• How to add a DTS Package as one step to a job manually?

  When scheduling a DTS package, the command for the step is created as encrypt hex like: DTSRun /~Z0…

  Kent Zhou

  4 replies

  17 years, 1 months ago

  By: Kent Zhou

• String or binary data would be truncated

  Hello everyone, When one developer tried to update the records using Management studio, got error:S…

  Judy Why

  9 replies

  17 years, 1 months ago

  By: David-1011936

• SQL Server Agent jobs

  Hi all, I recently installed ms sql server 2008 64 bit on some machines. I then reached a point whe…

  Niyala

  1 replies

  17 years, 1 months ago

  By: Matt S.-364742

• Operators not being notified from agent

  Hey all, I do not yet know why, but I have a new instance in which my operator groups are not being…

  Adam Bean

  2 replies

  17 years, 1 months ago

  By: Adam Bean

• Clustering or Replication

  Lets say i have a Server on locations......Us and Canada Where i have a SQL Server, now to ensure …

  parth83.rawal

  1 replies

  17 years, 1 months ago

  By: Eswin

• Client can't connect to SQL server ,but the program still work(SQLSERVER 2005 enterprise edtion)

  THE SQL server LOGIN error message: =================================== cannt connect to server se…

  webc

  6 replies

  17 years, 1 months ago

  By: manoj2001