SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• inside sql server 2005 books, are there 2008 versions of any of these?

  I was told by a very good DBA i should buy all 4 "inside sql server 2005" books ( tsql querying, th…

  winston Smith

  2 replies

  16 years ago

  By: winston Smith

• SQL 2005 Installing DTExec on Application Server

  Hi We have application servers for Dev, QA and Production. I would like to install only the client …

  dave-0

  1 replies

  16 years ago

  By: Gift Peddie

• Question about triggers

  I have a web page that lets the user key in data to update table1(EnterpriseScheduleDefaults). The …

  Coriolan

  2 replies

  16 years ago

  By: Coriolan

• table schema

  Hi,I want to know that with which command I can transfer my table from a schema to another schema??…

  x198yn

  1 replies

  16 years ago

  By: Ron McCullough

• Copy of database is much larger than the original

  Hi, Does anyone have any idea what might be causing this? I needed to recreate a database in a diff…

  paul.goldstraw

  16 replies

  16 years ago

  By: paul.goldstraw

• Adding Dataset 1 to Dataset 2 to make Dataset 3

  This is View 1: SELECT d.ITEMNMBR, d.ITEMDESC, d.ABCCODE, d.UOMSCHDL, Month6 = SUM(CASE WHEN b.DOC…

  paula_sql

  5 replies

  16 years ago

  By: paula_sql

• SQL Error 53 when trying to delete system maintenance plan

  Hello, a maintenance plan was created prior to renaming the server on which SQL2k5 was insta…

  robertleftwich

  6 replies

  16 years ago

  By: palipatanap

• Repository for Useful SQL Queries

  I would like to get an idea of what solutions people have used for this. We have half a dozen peop…

  JuanBob

  1 replies

  16 years ago

  By: emily-1119612

• Server front-end NAS back end?

  A manager proposed using Windows server 2003 as a front end for sql 2005 and storing the production…

  fizzleme

  2 replies

  16 years ago

  By: fizzleme

• Cannot Reinstall SQL Server 2005

  I received an older (Windows XP Professional) DELL laptop as a "take-home" development machine. Th…

  Robert Domitz

  4 replies

  16 years ago

  By: Robert Domitz

• Error Log

  What kicks off sql server to create a new error log? I am troubleshooting an issue that started on …

  bpowers

  2 replies

  16 years ago

  By: bpowers

• Row Count in Stored Procedure

  HI I need to put a row count in my SP but when I do it doesnt show how many rows there are it just …

  guestuser31

  4 replies

  16 years ago

  By: Steve Jones - SSC Editor

• What are some tips to improve performance of dynamic SQL

  I have one SP that shows up as using the most resources on my SQL Server and have looked at trying …

  andegre

  3 replies

  16 years ago

  By: Grant Fritchey

• Unable to deallocate a kept page?

  Does anyone have any insights on this error: "Unable to deallocate a kept page. [SQLSTATE HY000] (E…

  Gloriann

  13 replies

  16 years ago

  By: Thad Kovalchik

• Question about proper practices on Hierarchical data

  Greetings everyone 😀 I am responsible for maintaining and further developing the reporting data war…

  shannonjk

  3 replies

  16 years ago

  By: GSquared