Nope, even earlier - pre 6.0!...

CirquedeSQLeil (11/29/2010)

---

On the flip-side, I see your point and think that weekends are the times for doing deployments. Less impact to the business and make sure we have people...

Jack Corbett (11/29/2010)

---

Well, I took a major tech break over my Thanksgiving holiday. The only time my computer was on since I left work last Wednesday was Thursday afternoon...

GilaMonster (11/29/2010)

---

In other news...

The project from hell (the one that I spent evenings, nights and weekends on to try and meet impossible deadlines) has had the go-live date pushed out...

Jeff Moden (11/26/2010)

---

bjhogan (11/26/2010)

---

Have you tried doing this through Powershell? You can easily access the the SQL Server SMO to script out the objects to a file. I...

da-zero (11/27/2010)

---

CirquedeSQLeil (11/26/2010)

---

da-zero (11/26/2010)

---

Hmmm. I found a post of Celko where he says that he is the way he is online because he uses the "tear them down to build...

Steve Jones - SSC Editor (11/26/2010)

---

BTW, no idea what's happening in this thread, and not about to go through a few hundred posts over the last week. If there's something...

da-zero (11/26/2010)

---

I was going to ask you guys with the deal is with the Celko character, because I don't really know him. (Well, I've read an article or two from...

The 32-bit is running okay... you only need to set it up that way on the 64-bit server

kuppurajm (11/24/2010)

---

hi,

I have write the query like

-----------------------------------------

insert into tbl_xml(EmpId,EmpName)

SELECT

colx.value('id[1]','int') AS EmpId,

colx.value('name[1]','VARCHAR(max)') AS EmpName

--cast(colx.query('data(id) ') as varchar) as EmpId,

--cast(colx.query('data(name) ') as varchar) as EmpName

FROM...

You need to evaluate from the inside out.

SELECT MonthEndDate = DATEADD(dd, -1, DATEADD(month, (n.n-1) + DATEDIFF(month, 0, @startdate)+1,0))

FROM (SELECT TOP 100 n = ROW_NUMBER() OVER (ORDER BY NAME) FROM master.dbo.syscolumns)...

Let the...

You ought to put this into your signature...

Well, you've said it all, but you missed it also:

It works on: 32-bit

It fails on: 64-bit

It's trying to connect to: Access database.

Access databases are connected to through the JET database...

And it's also surprising to see how often this type of select statement is in a trigger, handling only one (random) record instead of all of the records being affected.