SQL Stored Procedure Name - Dumb Question

[malcolmt]

It's late in the day and I'm about to go home without an answer to this question.

I hope you can help and I'm sure it will be a simple answer to a dumb question.

I have numerous existing crystal reports (v9) which use MS SQL Server 2000 stored procedures without any problems.

I have just noticed that any new reports I am creating show a number after the stored procedure name in the database expert and then thereafter whenever a column is referenced in the report.

All of my previous reports do not have this number after the procedure name.

This caused an error when i copied some formula code from an old report to a new one as the stored procedure names no longer were the same because of the ;1 at the end of the name.

It is happening on multiple client machines and against multiple SQL servers.

Any clues?

Thanks,

Malcolm.

 

[malcolmt]

I think all is OK now with thanks to Mo.

Don't work with sp's very often so the numbers did not look familiar.

I'm fairly sure now that I had previously renamed other sp's after doing a set data source location, so was not seeing the numbers.

Malcolm.