If I'm understanding everyone correctly, I think people are saying that we can do away with the stars all together as they do not add value. I'm leaning that...

Of course we're all so busy trying to get you to change your design, we're kind of ignoring your actual question:

quote:

---

is...

You might be able to use smalldatetime, which gives you January 1, 1900, through June 6, 2079. That is only four bytes as well.

quote:

---

Also any network "drives" you have need to be mapped permanently WHILE YOU ARE LOGGED in as the MSSQLSERVER account. Not using...

Is there a trust relation set up between the two domains? Have you created a login in SQL Server for the user in the other domain?

I have not tried this myself, but I suspect that you're having a problem, because SQL 2000 was installed as a default instance. I think MSDE has to be...

I have mixed feelings about that as well. From what I've seen, most of the gurus are pretty knowledable. I think it would be difficult to read/post to...

Would a trigger serve your purposes, or is there data transformation that would cause too much overhead?

Is there a reason you're not using DateTime?

If you want to use file groups so that you can backup parts of your database at different intervals, you do need to backup your tables and indexes at the...

There are lots of ways, depending on your budget. The best solution would be to get some sort of monitoring software such as Patrol or HP OpenView. These...

If you execute the following, you should be OK.

updatemsdb..sysjobs

setoriginating_server = CONVERT(NVARCHAR(30), SERVERPROPERTY('ServerName'))

go

1 GB isn't very much. I've seen the OS routinely take up that much or more by itself.

I believe that it is as I suspected; the delay...

How much physical memory is on the server, how much memory is used during those peak times, and how much memory did the vendor set for fixed allocation?

If I had...

Can't explain the errors, but you would not expect it to fail over in this scenario. If you go into cluster manager and look at the properties for the...