Gail *may* have gone to bed already, she's across the pond, so I'll try to help in the meanwhile until she can bring her expertise back to bear. 🙂

This article...

I agree with George above.

Most of the tools you see out there are for either complex, highly repetitive and annoying tasks you'd do against incredibly large database networks, or to...

Jeff Moden (9/19/2010)

---

We gave the users their own "report" server and we updated it every night at midnight with one of those very nice EMC clone/snapshot updates. And, believe...

Because you're selecting these columns directly: ListingID,StreetAddress, City, [State]

They will need to be in the group by clase. Emaliagent and the rest shouldn't be. Think select distinct. ...

You're absolutely correct, and it may be that I've made a poor assumption. Let's take one extra step back. What are you using this counter for? I...

Barking, if you'll look in the other thread you posted regarding transactions, you'll notice a discussion, and explaination/workaround, to this.

EDIT: Allow me to extrapolate slightly since this part wasn't covered...

You...

Well, I think he's...

New DBA just in way over his head....

SQL Express 2k5 9.00.3042.00 Desktop machine.

Sorry it took a bit, I went out and partied last night. 🙂

Os-984017 (9/18/2010)

---

But you cannot make a new table with records from other tables in one statement. I was hoping there might be an easy way (or do both steps into...

You're running passthrough queries from Access, right?

If so, SQL Server is a two part statement. First 'create table blah AS ( bId int, value1 varchar(50))... etc.

THEN, you do an...

pravin.sawant99 (9/18/2010)

---

1) Data Retrieved in Grid by multiple users & saved with the help of stored procedure. But first user should be able to update other should get message "Data...

For posting sample DDL/tables and data, please do a quick check in the link in my signature, will help out tremendously.

Ah, I see the confusion.

You want to test the table to see if the table has the same name in two locations? Can it be any two locations, or...