What is the ans for the below query I gave d and like 2but i

Question

Hi frnds What is the ans for the below query I gave d and like 2but it's a wrong. which will be the output of the following code segment? Declare @my_name char(10) = 546875.5 Set @my_name = @my_name +'100' Select @my_name 1. 546875.5100 2. 546975.5 3. 546875.5 4. Conversation failed 5. None of the given output

Answer 1

I managed to resolve the issue by deleting a phantom user (It was a people icon with a ? mark.  I've never actually seen it before) in the Remote Desktop Users screen and then rebooting the server.  I suspect this may have been causing a problem with the remote connection; although the error message definitely wasn't pointing that way.  Thanks for your help and suggestions.  You pointed me in the direction of looking at the permissions.

Answer 2

I would still check the permissions on the folders/files you are trying to access through your code.  Check the permissions on a server that is working verses the one that isn't.  Even if you are using Administrator, the permissions could still be off, I know just from experience.  Good Luck

Answer 3

I had thought that might be the issue, too, but the id I'm using to get in is an Administrator.

Answer 4

The only thing I can think of is that there might be some permissions error on that one server.