Must Declare Scalar variable
-
Hey guys, i have wroted some sp's on some server and they used to work well on that server. then i took a backup of the database and restored it on another server so when i tried to run my sp's i got the exception "Must Declare Scalar Variable". for instance:
Declare @BankName int;
Set @bankname = 1;Results in: Must Declare Scalar Variable @bankname. any help. thank you.
-
Hey guys, i have wroted some sp's on some server and they used to work well on that server. then i took a backup of the database and restored it on another server so when i tried to run my sp's i got the exception "Must Declare Scalar Variable". for instance:
Declare @BankName int;
Set @bankname = 1;Results in: Must Declare Scalar Variable @bankname. any help. thank you.
The SQL Server instance you restored to is set to case sensitive, therefore the you have not declared
@banknameNever underestimate the power of human stupidity RAH
-
The SQL Server instance you restored to is set to case sensitive, therefore the you have not declared
@banknameNever underestimate the power of human stupidity RAH
ok Sir, i understand that but i want a solution.
-
ok Sir, i understand that but i want a solution.
So think about what I said, your sql server settings need to be changed, go find the setting and change it. Note depending on what database you have installed you may need to reinstall the sql server instance to change that setting. I suggest you prove that I have identified the problem first!
Never underestimate the power of human stupidity RAH
-
So think about what I said, your sql server settings need to be changed, go find the setting and change it. Note depending on what database you have installed you may need to reinstall the sql server instance to change that setting. I suggest you prove that I have identified the problem first!
Never underestimate the power of human stupidity RAH
yes sir you have identified the problem. My Database is MS SQL 2005 Developer Edition. when I installed it in "Collation Sitting" step of the wisard i checed "Case - sensitive" checkbox.
-
yes sir you have identified the problem. My Database is MS SQL 2005 Developer Edition. when I installed it in "Collation Sitting" step of the wisard i checed "Case - sensitive" checkbox.
I think with 2005 you need to reinstall the instance, you may want to look into changing the collation settings but I don't think you can change the case setting.
Never underestimate the power of human stupidity RAH
-
I think with 2005 you need to reinstall the instance, you may want to look into changing the collation settings but I don't think you can change the case setting.
Never underestimate the power of human stupidity RAH
Thank you, Sir. 100 :rose:
-
Thank you, Sir. 100 :rose:
Ali Al Omairi wrote:
100
What it mean it's a virtual points to Mycroft or bless of 100 year to live.:~
Regards, Hiren. be good(Help people in CP),do good(Vote if one finds helpful) all will happen good, In case happens bad(You are getting downvote for your best try to help OP) it will be good for later after(Countered with more points by humble member). - Gita sar in context of CP. -So Guys don't care about downvote believe in you.
-
Ali Al Omairi wrote:
100
What it mean it's a virtual points to Mycroft or bless of 100 year to live.:~
Regards, Hiren. be good(Help people in CP),do good(Vote if one finds helpful) all will happen good, In case happens bad(You are getting downvote for your best try to help OP) it will be good for later after(Countered with more points by humble member). - Gita sar in context of CP. -So Guys don't care about downvote believe in you.
Sir, In Jordan we use the expression "A hundred of flowers" often to say that every thing is ok. we also use it to thank people and to say hi to them.
-
Sir, In Jordan we use the expression "A hundred of flowers" often to say that every thing is ok. we also use it to thank people and to say hi to them.
Interesting cultural tidbit, Ali. I never know what I'm going to learn when I stop by CodeProject. :-D
Will Rogers never met me.
-
Sir, In Jordan we use the expression "A hundred of flowers" often to say that every thing is ok. we also use it to thank people and to say hi to them.
That's good to know, Ali. Thanks 100 :rose: to you too for that.
Regards, Hiren. -"I don't know, I don't care, and it doesn't make any difference".
-
I think with 2005 you need to reinstall the instance, you may want to look into changing the collation settings but I don't think you can change the case setting.
Never underestimate the power of human stupidity RAH
Sir, Since you told me so i was trying to reinstall the software but i had some problem with some components 1- MSXML6 2- SQL Server Database Services what can be the reson
Call me "Abu AlHassan", Please.