i changed the password using sysadmin user.

after that i tried to connect with normal user, same error occurred

only sysadmin can able to login.other users can't able to connect to the...

i want to know how to give view db access to a user on his specific database.

ex: In SSMS, If one user has a db owner permission to...

hi all,

for my second question, i used the below statement

USE MASTER;

GO

DENY VIEW ANY DATABASE TO PUBLIC

it restricts the public users to access the DB.

here i am getting one problem....

hi

i got it

Thank you very much for the reply.

hi justanewone ,

thank you very much. i got it

i have created a stored procedure, in that using the while loop and row_numbers() between values, it was solved...

hi saurabh.dwivedy

this works perfect to my requrement

thanks you very much

rock..

Hi nageswara.dhaveji,

this works fine.

thank you very much for all your support on this issue.

thanks and regards

ROCK...

hi nageswara

same error boss

any idea please check the test data in my earlier mail

thanks

ROCK...

hi Florian Reischl,

i am gettign the same error,

Msg 536, Level 16, State 5, Line 5

Invalid length parameter passed to the SUBSTRING function.

The statement has been terminated.

for '+' every hting...

hi mark

i have tried oyur code. same error occured.

thanks

ROCK..

hi mark

the above he said its not working.

update emp_data

set firstname=substring(name,1,(charindex('+',name)-1)),

lastname=substring(name,(charindex('+',name)+1),(len(name)))

you are right, can you help me with the code to modify.

its urgent

thanks

ROCK...

HI

thank you very much this works fine..

ROCK...

hi

same error no change in that

i am using sqlserver 2005

thanks

ROCK.

hi yesterday i did that using the varialbe and dynimically executed. i got it..

i use the below query

declare @var1 varcahr(300)

set @var1=tablename from firsttable;

exec('select * from'+@var1')

this works

but my requirement is

like...

hi

i know this query, actually the problem is, in the first table the columns are automatically generated from the application and also their fields...