SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• T-SQL to Generate T-SQL

  Ok, i'm a developer and I got feb up writing the same boring crap day in and day out.  So ive …

  GaryMcAllister

  3 replies

  19 years, 5 months ago

  By: GaryMcAllister

• Memory exhaustion issue

  I have a few very large tables. When I run a query, it fails with a primary filegroup is full error…

  alvin-242020

  1 replies

  19 years, 5 months ago

  By: Yelena Varshal

• Performance Differences -Standard vs. Enterprise (e.g. Intraquery parallelism)

  Does anyone know with certainty that Intraquery parallelism is available only in 2005 Enterprise, a…

  TDuffy

  3 replies

  19 years, 5 months ago

  By: MVDBA (Mike Vessey)

• Try..Catch code template using transactions

  Does anyone have a code template or a good example using the new Try..Catch error trapping methods …

  Ted Smith

  1 replies

  19 years, 5 months ago

  By: Walter Tucholski

• Import/Export Database Users

  Enterprise Manager in SQL Server 2000 allows to import/export users from one database to anoth…

  Tim F.

  1 replies

  19 years, 5 months ago

  By: Jared Metzger

• Question: Deprecated stored procedures?

  Does anyone know if the stored procedures sp_add_maintenance_plan, sp_add_maintenance_plan_db, sp_a…

  Brian Munier

  2 replies

  19 years, 5 months ago

  By: Brian Munier

• Import doesn''t import every table

  Hello there, I've just imported an mdb file file to my MS SQL 2005 server and have realised that it…

  Oliver Richardson

  5 replies

  19 years, 5 months ago

  By: Oliver Richardson

• renumbering

  I have a 50,000 records table and now i need put a new field (id_x). Do you know how i fill 'id_x' …

  antonio arciga

  3 replies

  19 years, 5 months ago

  By: Peter Schott

• ANSI PADDING IS SET TO OFF

  Hi I have set set the option in my database using sp_dboptions to Ansi padding off and checked it …

  PAUL STANLEY

  5 replies

  19 years, 5 months ago

  By: Peter Schott

• How to Comit Trans

  Hi all... I have a procedure that has about ten insert querrys and i would like to know what is the…

  BuilderBits

  3 replies

  19 years, 5 months ago

  By: BuilderBits

• Carriage Returns

  Since upgrading to 2005 from SQL 2000 I've noticed that I'm unable to enter a carriage return in a …

  kmarshall

  2 replies

  19 years, 5 months ago

  By: kmarshall

• wizard to generate diagrams of table relationships via public/private keys and sprocs

    i have just come to a new job and new databases. there are no diagrams for a rather large da…

  winston Smith

  3 replies

  19 years, 5 months ago

  By: Heiko Hatzfeld

• SQL Web admin on SQL Server 2005

  Hi, Anybody can tell me if SQL web admin works with sql server 2005 express????? Thanks Kindest…

  degrem_m

  1 replies

  19 years, 5 months ago

  By: Arun NS

• UNION ALL between two recursive WITH

  DECLARE @user-id uniqueidentifier SET @user-id = 'EC3C39B4-0E80-4EE9-A235-364A17B3A92C' --------…

  degrem_m

  2 replies

  19 years, 5 months ago

  By: degrem_m

• Displaying text of an index

  Is there any system stored procedure to display text of an index? (like sp_helptext)

  Haldun Degirmenci

  1 replies

  19 years, 5 months ago

  By: rsharma