tmc (12/3/2007)

---

I'm a DBA in a large organization. Recently I was working on requirements for a new SQL Server with various groups in IT. I experienced a problem...

Lynn Pettis (11/30/2007)

---

I'm...

Assuming you CAN open it and scan all of the way to then end - how about just exporting the data from access? to CSV for example since it seems...

Tyshdude (11/30/2007)

---

Good question - I've seen FTP mangle some files in the past.

I just checked it out - yeah, I can get into the DB in Access 97 and open...

Cool - Just wanted to be sure we were all there:)

I'll be the one yodeling in the back....

Jeff Moden (11/30/2007)

---

Heh... and what better way to do that than to...

Took me a second to figure out you DON't wnat them there through remote desktop.

Look at the updated post above.

Best way to get the service name is to look at the properties of the service in the Control Panel/Administirative Functions, services. Highlight the service in question, right-click, properties,...

Now wait a second here...

you've now jumped onto something entirely different by using irrational numbers and decimal numbers as if they were interchangeable. Naughty naughty there Sergiy...

jreed (11/30/2007)

---

Interesting Ken. Thanks for that info as well. I will try your query out and get back to you on that as well.

I am still...

Functions don't allow for dynamic calls. You're going to need to do that logic OUTSIDE of a function.

You can run it from the command line. It's actually a better way to manually start SQL server than running the executable directly, IMHO.

Syntax looks like

NET START servicename

NET STOP...

Jessica (11/30/2007)

---

Hi Matt,

I got the following errors when trying to create a temp table in that view:

Msg 156, Level 15, State 1, Procedure vwMinHTOXLinc, Line 20

Incorrect syntax near the keyword...

mgerszew (11/30/2007)

---

My opinion is that a data model should be designed by someone knowledgeable in database design, but the important thing that your question doesn't even address is the interface...

Here are a few things to look at to help you out:

- you don't want null Account_ID's (since you're doing an inner join in the outer query). Assuming that's...