Thanks Lowell,

Can you shed some more light on accessing SQL Server DB Engine from an UNIX platform.

Change it to the SIMPLE recovery Model.

Also, you might want to check for the active trancation before you do anything. run this to check the active transaction:

DBCC OPENTRAN

jai verma (6/9/2010)

---

Hi, we recently migrate our SQL2005 server on a upgraded server,after installtion we chnaged the ip of server.

we publish a application on citrix layer based on this dbserver

but...

Did...

da-zero (6/9/2010)

---

You can write a SQL query to read from the Excel source, but it doesn't support all the language syntax.

So, I would just read the contents of the file...

Below query is giving me desired output, but can we merge both these query to have just one single query:

SELECT cdi.xidxrecid,CFA.ORGID,

...

sorry I mean I am not getting the desired output.

Lowell (5/27/2010)

---

V in your first query of the UNION ALL you have this as part of the WHERE arguments:

CFA.ORGID IN ('*','SERVICE','4C0C6A2U7P','4X9A8F2U5A')

but in the second part of the union...

Finally I was able to import the file. Though I had to change that file manually but now its over. Thanks.

yup did it after changing to Raw data and then directly importing it through import/export wizard. so far running so good.

Lowell (5/25/2010)

---

ugg; one-time imports are sometimes the most time consuming...can we see a row or two of sample data? enough to make a format file so you could test a...

Lowell (5/25/2010)

---

Vishal in my experience, a text filefilled with INSERT INTO....commands is much much slower than using BULK INSERT or bcp to bring in a text doucment filled with raw...

Chris Morris-439714 (5/24/2010)

---

DROP table #t1

DROP table #t2

create table #t1 (catid int, orgid varchar(10))

create table #t2 (catid int)

insert into #t1 values (1,'PETER')

insert into #t1 values (2,'a01')

insert into #t1 values (3,'*')

insert into...

Indeed a good article but practically difficult to use.

I raised it in connect. Lets see if they support it there.