SQL 2000 to 2005 Migration Questions

1

Adding New Parameter to a existing Crystal reports 9.5
I have a exsiting crystal rpt that passes 5 parameters to a stored proc.  We have added 1 more parameter to the procedure now when attempting to run the crystal rpt it errors out with proc expects parameter “new” (new being the added parameter).   I have been unable to get around this. Can anyone help. [...]

Answer Question   |  December 16, 2010  6:32 PM
Crystal 9.5, Crystal Reports 9, Parameters, SQL 2000 to 2005 Migration
asked by:
5 pts.

Process ID 174:102 owns resources that are blocking processes on Scheduler 2.
Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the problem until another 2 days. Also [...]

Answer Question   |  September 10, 2010  4:15 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Server 2005, SQL Server upgrades, Windows, Windows Server, Windows Server 2003, Windows Server 2003 SP2
asked by:
5 pts.

Trouble installing SQL Server 2005
I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

Answer Question   |  September 9, 2010  8:06 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Installation, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 administration
asked by:
5 pts.

SQL 2005 Password
If you move a sql 2000 database to sql 2005 which admin password does it have now.

Answer Question   |  June 6, 2009  3:12 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Database, SQL migration, SQL passwords
asked by:
20 pts.

1