SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• archiving off records in table with clustered (identity) primary key

  I need to archive records that are "completed" and older than 32 days as a rule the order of record…

  DataDog

  6 replies

  14 years, 10 months ago

  By: george sibbald

• The log or differential backup cannot be restored bcoz no files are ready to rollforwad

  Hi, I am running the following script to attempt a restore of a Transaction Log backup. Following m…

  Senthil Varadharajan

  3 replies

  14 years, 10 months ago

  By: Gail Shaw

• How best to push large DB Copies over the wire on a regular schedule

  I’m trying to not be verbose so if you have any questions please don’t hesitate to ask. In short th…

  YSLGuru

  18 replies

  14 years, 10 months ago

  By: george sibbald

• SPLIT TSQL Between two character

  Hi, I need some help. I already have something like this: DECLARE @Custom_Properties varchar(100) S…

  ja0

  14 replies

  14 years, 10 months ago

  By: WayneS

• Best approach to transfer data between 2 SQL databases

  Hello, We are working on a middleware with backend as SQL database. We have a requirement to get da…

  vishal.shinde

  2 replies

  14 years, 11 months ago

  By: vishal.shinde

• Split sentence into words

  Hi, I have a column named Address in a table. I have values such as 12-15 Hardley Street 2A-C Hardl…

  cmrhema

  7 replies

  14 years, 11 months ago

  By: daxz

• dynamic column headings and rolling 3 months

  I have a poorly designed accounting forecasting table that contains categories, periods and period …

  tmatthes

  1 replies

  14 years, 11 months ago

  By: Richard Warr

• The interesting case of cost threshold for parallelism

  Hi , Just come across an interest case while investigating an SP. The query plan shows parallelism …

  Eoin The Forge

  2 replies

  14 years, 11 months ago

  By: winash

• How To install SQL Server 2005 on External HDD

  Hi all, I am new in this forum, my name Eddy.. I got the problem in instaling sql server 2005 on my…

  eddywibowo89_new

  5 replies

  14 years, 11 months ago

  By: eddywibowo89_new

• Enterprise edition installs standard edition

  Hello guys something weird is happening to me, I have the installer for enterprise, but when I chec…

  ricardo_chicas

  9 replies

  14 years, 11 months ago

  By: ricardo_chicas

• call a cursor in a procedure

  Hi... how to call a cursor in a stored procedure. any help pls...

  BeginnerBug

  10 replies

  14 years, 11 months ago

  By: WayneS

• as400 odbc client

  I've got a crazy situation where we have been timesharing on an as400 box. Now we want to move the …

  ericwenger1

  5 replies

  14 years, 11 months ago

  By: UAMCRay

• Replace Ave with Avenue

  Hi, I have a table which consists of a column named Address I am supposed to replace in the column,…

  cmrhema

  1 replies

  14 years, 11 months ago

  By: Lowell

• Service Broker and SQL Log

  I have 10s of thousands of these messages daily in my SQL logs: Message The activated proc [dbo].…

  Tony Fountain

  6 replies

  14 years, 11 months ago

  By: Tony Fountain

• select statement

  i have a table as follows... ------------------------------- From date | To _date ------------…

  BeginnerBug

  7 replies

  14 years, 11 months ago

  By: BeginnerBug