johncyriac (11/25/2008)

---

Hi friends

I am Not able to connect SQL 2005 intance

from windows 98 ODBC as well as SQL 2000 Query Analyzer,

Our problem is a number of windows 98 clents...

joel_langlois (11/25/2008)

---

Hi Folks,

I have a table with an identity column that increments by 1 per record…

I’ve been adding records and removing records and I noticed that when I remove a...

right click on the Agent and select Start, and still if does not work,...

garethmann101 (11/25/2008)

---

Is there a way to do a 'find and replace' in all stored procedures of a given database? If not then is there at least a way to do...

huuhieu004 (11/25/2008)

---

Hi all, I have a database setup on three Server. And a an application. I used SqlServer2005. Example model :

Server A(DB) ServerC

I created a linked server "SrvName".

I...

winash (11/25/2008)

---

krayknot - the cursor solution you've provided is not the best approach. For most situations we don't need to use a cursor.

In the links that were provided are good...

yes practically it is impossible as it contains the transaction information only. but depending on the required information,...

welcome

DECLARE @MyResult TABLE (PK Int, SumOfPockets Varchar(4000))

DECLARE @pk varchar(1000)

DECLARE @MyString Varchar(4000)

SET @MyString = ''

DECLARE cMyTable CURSOR LOCAL FAST_FORWARD...

Tanveer (11/24/2008)

---

HI,

Consider a scenario where a developer has fired a huge query in sql server 2000 with Begin Tran and by mistake or accidently has not commited that transaction with...

will it work??

it has two columns

ID(int) IDDesc(varchar)

1 ...

bharathi (11/24/2008)

---

Hi,

SELECT

C.RCN_ID As CandidateID,

I.RIV_ID As InterviewID

FROM

Abacus_Rec_INTERVIEW AS I

INNER JOIN

(SELECT

RCN_ID

FROM

...

Mr J (11/24/2008)

---

Can someone please explain to me why this is not working ??

CREATE TABLE test AS

(SELECT A, MAX(B)

FROM ...

Patrick Ige (11/24/2008)

---

Thanks Kraynot but if i insert GO

I would have to declare all the variables

Pls test it.

krayknot (11/24/2008)

---

Patrick Ige (11/24/2008)

---

I have and update and insert statement in a...