(trying this again).

I would use ASP.NET 2005, and simply go with the built-in user controls. there's just about zero coding required.

Drop a formview control on the page, point the formview...

liuc (3/6/2008)

---

Ok now it works.

I setup the sql agent access method on "This account" using the same account used to access the remote folder and the job works giving this...

Laurie Thompson (3/6/2008)

---

Hi Matt,

Thanks very much for your input. I indexed as you said and it does run quicker. However, when I ran the "Index Tuning Wizard" it recommened:

[Open%] ,[High%],...

Vista Home Premium will not allow you to run SSRS. It just plain won't install from what I can tell. As being a "home" product, MS saw fit...

Jeff Moden (3/6/2008)

---

Yes, I agree... if you're going to do a lot of ETL, a separate DB with SIMPLE recovery is certainly in order. In fact, if you really...

Is there a chance to use the SP to generate the table?

For what it's worth - using SELECT...INTO instead of CREATE...INSERT INTO... would allow you to not have to specify...

Loner (3/6/2008)

---

If the shopper database is small, it has no problem, but if there are more than 2 million shoppers, right now they put it in LDAP database because when...

PhilM99 (3/6/2008)

---

This may be typical, so I need somewhere to read more in detail.

Currently:

I have a web server which interacts with clients. It has a SQL 2000 database which I...

Careful what you ask for. Jeff purportedly serves them up with the use of a slingshot (My take on that...

I'm not quite sure what you mean by a "function update script" - but the UPDATE clause is alive and well in SQL Server.

yours looks something like

UPDATE dbo.ClippershipImport

SET TRACK_NO...

Esined (3/6/2008)

---

It'll be wonderful if someone knows why -- If I set WindowStyle property to "Normal", the error will appear. However, once it's set to "Hidden", whalla!!!!

Problem solved (and...

You can't "build" the expression INSIDE Exec. You have to build it FIRST, then pass it fully built into Exec.

As in - (I haven't checked to see if you...

Me neither. Actually - rubbing "them" the wrong way is a bit of my specialty:)

Then again - there's apparently no expectation of performance - you just got to be...

Yes - with a big "asterisk". Shrinking database files tends to fragment the internals quite a bit, so once you shrink you will also want to run a reorg,...

I'd also consider making on a derived column of the other. meaning - days as a factor of months in service, or vice versa.