Looks like you need to setup linked servers to your Access databases. You can find more information about those in BOL 9Books Online, the SQL Server Help System). ...

To truely help you, more we need. Please provide the DDL (CREATE TABLE statements), sample data (INSERT INTO statements), and expected results based on sample data.

For help with this...

Well, yes, an error it is. Without know more, not much more we can do.

What are the source and destination data types being used?

I'm not sure about the file system compression. Before we purchased HyperBac, I was compressing the backup files using PKZip to reduce the amount of disk space used by...

Correct you are, SQL Server 2005 features use you can not while in compatibility mode 80 (SQL Server 2000).

Unfortunately, I won't be coming to PASS either. No funds available. 🙁

steyaert (10/28/2009)

---

No, I did not run the code separately. As a trigger, the "deleted" table would not exist, so the code would not function successfully as a stand-alone.

I did...

gmamata7 (10/28/2009)

---

Looks to me like there may have been a problem during the in-place upgrade. Not really sure where or what you need to look into as all my upgrades...

Glad I could help. Looks like you found another reference that assisted as...

Actually, having just looked at BOL, there are several examples using multiple variables. Looks like they aren't necessarily using variables like I had setup, but they are there. ...

Looks to me like there may have been a problem during the in-place upgrade. Not really sure where or what you need to look into as all my upgrades...

ssismaddy (10/28/2009)

---

Hi, I m trying to get the following result using getdate() :

2009-10-28 08:33:00.000 i.e: I want precision only in minutes and I don't want to display seconds..

...

Roy Ernest (10/28/2009)

---

I shouldnt take both together. Pain killer in the morning and muscle relaxant in the night. The doc told me that the muscle relaxant is going to make...

Why?

Careful mixing the pain killers and the muscle relaxant. My...