Jan Van der Eecken (10/5/2009)

---

GSquared (10/5/2009)

---

jcrawf02 (10/5/2009)

---

My project this weekend has been Artillery Fungus[/url], unfortunately. I'm trying the mouthwash/toothpaste solution on that link later tonight or tomorrow, depends when it...

"Starting to think 'too' business" - it happens. 🙂

Go with the temp table idea. It's the best option.

That makes more sense now.

The only thing I can think of is adding a VBA "on startup" script to the Access file which would log that someone is using it....

The only methods I can think of would be unstable and untrustworthy.

Any reason to not have multiple Access files and bypass whatever issue you're running into?

Is there some particular reason to not have SQL back up the database? I'm sure there are ways to back up the file directly, but they're all going to...

jcrawf02 (10/5/2009)

---

My project this weekend has been Artillery Fungus[/url], unfortunately. I'm trying the mouthwash/toothpaste solution on that link later tonight or tomorrow, depends when it rains. Spent time this weekend...

dsdeming (10/5/2009)

---

For what it's worth, you can accomplish the same thing with an outer join and an aggreaget function:

CREATE TABLE #Test(ID int IDENTITY(1,1), FirstName varchar(10), LastName varchar(10), Email varchar(10))

INSERT INTO...

Here's how I recommend doing deduping in SQL 2005/2008:

;with CTE (Row) as

(select row_number() over (partition by FirstName, LastName, Email order by ID)

from dbo.PERSONS)

delete from CTE

where Row > 1;

Here's a performance...

I've had bosses I would back up completely and support enthusiastically, and bosses I'd abandon at the slightest opportunity. Fortunately, more of the first than the second.

I always think...

I've used maintenance plans as a stopgap. Get something in place that backs up databases on regular basis and a few other tasks, while building the necessary scripts and...

Steve's reply to another copy of the post is here: http://www.sqlservercentral.com/Forums/Topic780179-61-1.aspx

I don't have a problem with it....

Francis Yee-483501 (10/2/2009)

---

First, THANK YOU a lot guys for the extreme support.

The code I quoted is just one tenth of the original program.

My purpose is very straight forward and the...

When you create an index, you can specify which filegroup to create it in. If you create the clustered index in a certain filegroup, then that's the table. ...

When Management Studio asks you which server to connect to, type in the IP address, add the correct credentials, and see if it'll connect.