If this is for a particular application, why not create an DB role in the DB... that set up will allow you to add several tables at a...

Open up SSMS and then use the object browser to drill down in to the Server\Database\Tables.. then right click on the table(s) in question and select properties from the context...

I would first terminal into the box and fire up SSMS locally to see that everything is running correctly. If yes, then I would check that you're access...

Would it be possible to set up a trust between the two domains to help with the migration?

Yes.. W2K3 Standard supports 4GB and Enterprise supports 128GB(x86) and 2 TB(64bit).

I would think the recommendations vary as wildly as the applications out there..and the scenarios.. will there be other...

The operating system Maximum..

Can you telnet to the box on port 1433?

Did you confirm in the operator properties that the 'GentranNotification' operator doesn;t have a schedule set?

If you are trying to diagram SQL 2000 DBs you need to use Enterprise manager.. SSMS cannot work with SQL 2000 diagrams..

Rich

"Unless I am mistaken, you would have to find out what groups the person is a part of, and then search through them to find out what group to mimic...

How are you populating that "referencenumber" value? from another SQL task?

I believe if you go into SSMS and under registered servers you click on the "integration Services" button and add your 2005 box you will see the packages listed under...

2005 has nested tables.. info here.. http://msdn2.microsoft.com/en-us/library/ms175659.aspx

Thanks

Rich

Hi Denise.. here is good place to start

http://msdn2.microsoft.com/en-us/library/ms189134.aspx

Thanks

Rich

yes.. you need to install the cluster first.. then install SQL Server. The cluster needs to have common disk space configured etc.

Thanks

Rich