Hi Chandrasekhar,

Are these instructions for IIS 5.0 or 6.0?  We are using 5.0 and I don't see an Application Pools folder under IIS not a DefaultAppPool folder.

Thanks again,

Pete .

Thank you for your input Brian.  It does seem logical to pursue the SQL Server 2000 MCDBA first, then 2005.

Pete

Hi Brian,

Like David, I would also like to pursue my MCDBA but I'm not sure if I should do it now with SQL Server 2000, or wait until 2005.  I'm...

Hello Joseph,

I found the problem.  You cannot install the SQL Server Management Studio software from a network drive.  The installation worked once I copied the msi file to the C:\...

Very true Hilary.  I will check the other stored procedure to make sure they are in place.

Thanks!

After a little persistance on my part and with the use of SQL Profiler, I discovered that there was a missing stored procedure named  sp_MSestimatesnapshotworkload. 

Pete

Good thought homebrew.  I'm fairly new to this forum.  I will move it over now.

Also, the is no other replication on this server.

Thanks.

Pete

Raj,

I did mention that the user account executing the snapshot does have access to the syspublications table.  I'm able to query the table in Query Analyzer without fail. 

If anyone out...

Hi Wayne,

Thank you for your reply.  We are attempting to establish test data from two different sources 'Cache' and 'Centura'.  We have the table struture, with the test data.  The...

Anyone?

Josh,

Please view Microsofts Knowledge Based article by clicking on the link below:

  http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q288/5/77.asp&NoWebContent=1

I hope this helps.

Pete

Hi Brendthes,

Thank you for your reply.  I will give this a try.

Pete

Thank you for your response stacenic, I will give it a try!

Hi Sharrell,

Thank you for the information.  I'm currently downloading the evaluation version of DBMS/Copy too see how this works.

Thanks again,

Peter.

Hello Allen,

From SQL Server 2000, I'm attempting to register a SQL Server 6.5 server and when I do, I'm receiving the following error message:

Login failed- User: Reason: Not...