SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Serious Performance problem on Production Machine!

  Hello all! I just started as a database coordinator at a fairly well funded non profit coming from…

  jligda 35032

  10 replies

  15 years ago

  By: Grant Fritchey

• Row locks and Transactions

  Hi, Can anyone tel How to find the Locked rows in a table . or to determine whether a row is locked…

  Narayana_17

  1 replies

  15 years ago

  By: Grant Fritchey

• Finding Duplicates

  Hello All, I have created a query to find the contact list from a database. However what i found ou…

  chaudharyabhijit

  2 replies

  15 years ago

  By: Ron McCullough

• Getting SQL Server Error - Please Help

  The client was unable to establish a connection because of an error during connection initializatio…

  Deries

  5 replies

  15 years ago

  By: Steve Jones - SSC Editor

• Extract XML values using SQL

  Hi I am trying to extract values from an XML file using SQL. My XML contains nodes named "forename"…

  chris.mcbain

  1 replies

  15 years ago

  By: Yogesh Potdar

• SP4 on 2005 Standars edtition (32 bits)

  Hi, I am doing a fresh installation and I would like to know if I need to apply SP1 to SP3 before a…

  Rem70Rem

  14 replies

  15 years ago

  By: george sibbald

• Using Variables in EXECUTE statement

  Hi All, just looking for some assistance in using EXECUTE commands in SQL2000. As a simple example …

  rferguson-989993

  7 replies

  15 years ago

  By: a.rajmane

• Reclaim space after dropping a table

  Hi I have a table in my DB that is 30GB in size. Once I drop/truncate the table, how can I reclaim…

  Rowan-283474

  6 replies

  15 years ago

  By: Jeff Moden

• DBCC SHRINKFILE shrinks below specified file size

  Hi, I'm trying to figure out why DBCC SHRINKFILE doesn't adhere to the specified file size of my da…

  hemul

  12 replies

  15 years ago

  By: seven.srikanth

• complex query

  create table #tab1( empno int, mark1 int, rank1 int) insert into #tab1 values (1,50,2) insert into…

  BeginnerBug

  9 replies

  15 years ago

  By: WayneS

• Replaceing multiple text with a space in a column

  I have a column with 2000 character text in a column like repair, need,network etc...I want remove …

  tulasinr

  4 replies

  15 years ago

  By: tulasinr

• Update Column Value using After INSERT Trigger on table with no Primary Key

  Hi Guys, I have a table with no Primary Key. I have a column that is null. But I want to set it to …

  niteshrajgopal

  8 replies

  15 years ago

  By: Evil Kraig F

• Create a foreign key constraint

  I have created a new table A Table A id Bid bsequence description Table A is using Table Bs id and …

  Pink123

  1 replies

  15 years ago

  By: Lowell

• Mirroring Question For Blackberry DB:

  SQL 2005 Dev (64bit) to SQL 2005 Std (32bit) mirroring? Hi All, We have installed BES 5 (Blackberry…

  rwishart

  2 replies

  15 years ago

  By: rwishart

• Copy data to update schema database

  I have a situation. I have a software application that creates a new database on install. But I a…

  randal.schmidt

  5 replies

  15 years ago

  By: Orlando Colamatteo