General

• Topics

  Started by

  Posts

  Last post

• INSERTS and UPDATES not writing and not generating an error??

  Hi All! I have a visual foxpro 9 application that uses SQL Server 2000 as a backend. The applicatio…

  Menachem Bazian

  4 replies

  16 years, 11 months ago

  By: Matt Miller (4)

• Very Strange Issue with DTS

  Hi All, I've had this DTS package running like a dream for donkeys years. This morning i was told t…

  Mr J

  1 replies

  16 years, 11 months ago

  By: Greg Charles

• View and SQL2000 performance

  I am being told by the hardware manager and IT director that having a large number of views saved i…

  David Lester

  5 replies

  16 years, 11 months ago

  By: David Lester

• Get the database given a sql task

  Hi All, I need to get the database name involved for any given task via sql... For example let's sa…

  Ak-763166

  5 replies

  16 years, 11 months ago

  By: Ramesh Saive

• Trigger problem

  Hai all, i am inserting the bulk data in my table(at a time 2 or more records).but i am wri…

  polo.csit

  1 replies

  16 years, 11 months ago

  By: Lowell

• Table Joins and count(*)

  Hi I have 2 tables as follows: table = blogEntry: => | BlogId | title | body | catid | DatePubli…

  loopman

  4 replies

  16 years, 11 months ago

  By: loopman

• Help With a Complicate Select Query

  I Have a table with this fields: Event_ID (PK), UserID, UserName, EVENTDATETIME, IN_OUT This table …

  Jose W Pagan

  4 replies

  16 years, 11 months ago

  By: Aram Koukia

• Database renamed accidently

  My SQL Server 2000 database was renamed without me consciously doing it and of course things failed…

  ahneave

  3 replies

  16 years, 11 months ago

  By: GSquared

• Rather critical perfomance issue

  First our configuration: Windows server 2003 R2 fully updated (64-bit) 32 GB of RAM and 4 Intel Xe…

  Randy-734603

  23 replies

  16 years, 11 months ago

  By: Randy-734603

• Error Message:Violation of PRIMARY KEY constraint 'PK_TD_SURVEY_RESULTS'. Cannot insert duplicate key in object 'TD_SURVEY_RESULTS'. The statement has been terminated.

  Hai, ALl my store procedure is: CREATE PROC SP_TD_SURVEY_RESULTS ( @pin_sParamvarchar(10) , …

  polo.csit

  2 replies

  16 years, 11 months ago

  By: Jack Corbett

• Hardware reqirement for SQL server

  * Alpha AXP, Intel or compatible platform * Pentium 166 MHz or higher (Pentium Pro, Pentium II …

  stellathomas555

  1 replies

  16 years, 11 months ago

  By: Michael Valentine Jones

• Running SQL 2000 in a virtual environment?

  We would like to run our SQL 2000 production box on our VMWare server. Our SQL 2000 has only two m…

  jsheldon

  4 replies

  16 years, 11 months ago

  By: NotManyPoints

• Disconnect vs close window in SQL 2000

  When I have finished a session in SQL 2K Query Analyzer I (religiously? superstitiously?) disconnec…

  jmcginley

  1 replies

  16 years, 11 months ago

  By: Mike - CI

• Size limit for SQL databases?

  Do you now if there is a size limit to SQL server databases? For example, is there a limit to numbe…

  alovegrove

  4 replies

  16 years, 11 months ago

  By: Gail Shaw

• Recommended Reading Materials

  I am looking for SQL books that will cover creating tables from LDAP and executing stored procedure…

  kabaari

  2 replies

  16 years, 11 months ago

  By: kabaari