Firefox works, IE doesn't.

Jack Corbett (7/16/2009)

---

Is the view in the same schema as the table? If not, then the schemas need to have the same owner. I actually have a blog...

Can I just go ahead and install the 2000 32bit client on my x64 machine? Will it work?

I don't have a 2000 x64 server.

I have a x64 laptop that I want to manage a 2000 32bit installation with.

Well crap then. I will just have to live with managing my 2000 instances with 2005. 2005 is just so painfully slow over any less than a 10mps...

Hmm. I will play around with the backup spanning option. This may help me out a bit. I would have to backup to multiple files and then...

The solution that I was thinking of before I posted this was to first insert the rows into a copy of the table with the identity column turned on, then...

I am getting updates to previous years data. Which could be an insert, delete or an update to data I already have.

No problem. I appreciate any help.

Lynn Pettis (5/26/2009)

---

When creating a partitioned view in SQL Server 2000, you also need to place a constraint on each table that ensures a record belongs to only one table,...

Upgrade this server to 2005/2008? Uh . . . nope. No upgrades on this server anytime soon.

What you are talking about is what I am trying to do. What is a SID identity column and...

That's the problem. I have to preserve the data that I'm getting. I can't modify it.

I figured that I could just setup a staging table with...

Thanks. That's exactly what I wanted.

One of the big things that I would like to see is the ability to right click on a table and then enter a table description. Why haven't they...