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. [...]
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 [...]
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.
If you move a sql 2000 database to sql 2005 which admin password does it have now.





