Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What Is This?
Message
General information
Forum:
ASP.NET
Category:
Reporting
Title:
Miscellaneous
Thread ID:
01452075
Message ID:
01452278
Views:
45
>>>When I select a stored procedure in the Database Export, the name appears with ";1" next to it. Calls to SQL also appear that way.
>>>Here's what profiler shows:
>>>
>>>
>>>exec "ApexGlobal"."dbo"."sp_RPT_Assembly_Cum_LT_Detail";1 4, NULL, NULL, NULL, NULL, 0, 1
>>>
>>>
>>>What is this ";1"?
>>
>>Semi-colon is end of line, next line should be parameters passed to SP.
>>1, 4, NULL .....
>
>The semicolon and 1 appear in all reports, whether or not params are used, so that's not it.

And that is what SQL Server Profiler shows you?
Did you try to execute that line in SSMS?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform