Yes you could. Install MSSQL 2k as a named instance and leave version 7.0 as the default instance. However, you will need to have separate copies of your...

Are you doing this in a trigger? INSERTED is not available outside a trigger.

Something like the following code is what you want.

SELECT EMPLEAVE.* FROM EMPLEAVE

left outer join EMP on EMPLEAVE.Empcode = EMP.Empcode

Where EMP.Empcode is null

You could create a DTS package to do this or you could write a script. Either way, there is no automatic table split.

Couple of things: How are you passing your @OldName variable? For column change this should be 'tablename.oldcolumnname' for sp_rename to work.

Also, under what security context is your dotnet...

Check your @recipient variable when the package fails. Probably the email address is longer than 50 characters allow in the variable. In which case a truncated (and therefore...

Check out sp_setreplfailovermode in BOL.

SQL Server 2000 provides a secure administrative link between the Distributor and Publisher and I don't think changing the password of the account under which SQL Server runs has any...

Keeping the two databases synchronized require the use of Replication. Look at transaction replication with immediate updating subscriber. You could find the how-to in BOL. Cheers.

Hey, see my answer to your post in the Administration forum. Cheers.

There is no way you could migrate your stored procedure codes straight from SQL Server into Oracle. For one, the codes are probably not compatible and you would have...

SET ANSI_NULLS is a database option and you could set it on or off at anytime. Use sp_dboption or (as advised by microsoft) use ALTER DATABASE command. You could...

Now, now that is something I wouldn't do if I were you! Doing that subtracts from the value of the exam as well as your sense of personal achievement....

I have come across this problem many times. I have never been able to determine the cause (probably a bug in the way security information are passed to the package...

Have you checked the "SQL Server Properties (Processor Tab)" options to confirm that you have correctly set the number of processors to use for parallel query as well as the...