I agree. I'll look around a bit more.

Can you give an example?

The thing is, you should be learning this stuff. 431 includes simulations, and you need to be able to actually do the work. Work with objects,...

You should be able to add a login from another domain. You might need an AD trust of some sort.

Easier to add the login with SQL Server (sql auth), set...

Don't do this. USe an identity, add a 2nd computed column if you must that pads things out with the 0s (meaning it's a char ) col.

SQL handles this well....

Please put these in the appropriate forum. A better chance of getting an answer.

Also, which version of SSAS is this?

Use Option B. There are functions to work with dates and you don't need to reinvent them. Too easy to make mistakes.

If you need to query on year or month...

If there's a chance for a lot of updates, I wouldn't do a trigger. Better to do with the archive.

I'd actually do a "with exists" test first

if exists( select xx...

Check the times on the servers and please let us know if you determine the cause.

In SQL 7, I believe the only way to do this is with an uninstall, reinstall of the server.

Seems like Dundas is the primary one I see out there.

You contacted their support?

Also, moving this to the reporting services area.

DO NOT USE REPair_allow_data_loss.

You can try to repair the table but moving the data out and reading around the structures, but it might not work. This is really worth the...

There aren't daily ones.

what are you trying to do? What is IMP?

Or what have you been asked to do? If you're new to being a DBA, there are quite a...

Is this DTS? Please post in the DTS area (I'll move).

One thing you can do is save this as a "VB" file. It's an option if you do SAVE As....

Do you really need SP4?

I doubt you'll get support on this. Any reason why the base OS can't be changed?

It's indicated in the registry keys, but it doesn't affect operation.