what you're saying doesn't make sense though..

unless they're storing data in the trigger file with the current date in..

data warehouse job completes

they drop a file

your process runs ONLY if the...

then id insert an entry in somewhere and then say if you see this entry, then dont do anything.

real pain though.. does the parent company remove the trigger file??

barunpathak (5/8/2009)

---

The file we are taking about here is just the trigger file. This file will not be moved or renamed or deleted. Basically this file will tell me datawarehouse...

Jack Corbett (5/8/2009)

---

Why not just schedule a job to run hourly and if the file exists process it.

Then the code in one job is:

If file exists THen

...

Thats what I figured..

Thanks Edogg.. appreciate you taking the time to answer! 🙂

artsaliv (4/28/2009)

---

But when I run the sql server manager studio I get this wizard to

connect to a server and my computer name does not appear on it. But...

JacekO (4/22/2009)

---

I do not know if this comment references the application in question but...

That is a good point JacekO..

To clarify, I was thinking about this question in relation to an individual app, however, I was interested to know just from a theoretical thing.

The...

Yep I'm with ya.. this should really only ever have 1 user, however, best laid plans and all that.. im sure I'll say that now and then all of a...

in this case, its a winForms app. I have 2 database objects, one to connect to one particular database, and another which can connect to various different databases.

I think...

well the other thought would be that if my connection were to blip.. i'd have to handle a reconnect in my code anyway..

ahh conflicting answers.. which is how i've been

Yes, it does not take much to reestablish the connection, however, if there is a performance boost to not closing it in the...

Thanks Steve,

I didn't know if the logins would store that.. though it'd be handy.. ah well.

Thanks for the link, i'll check that out shortly. I'm sure I'll have more...

RBarryYoung (3/31/2009)

---

torpkev (3/31/2009)

---

I'm sure this isn't the best way.. but you could build your sql into a string and pass the sort type (ASC or DESC) as a parameter and...

ah nuts.. i was hoping that there'd be something saved in one of the system tables

thanks