how impersonation can be used?

if i have created a user(imporuser) with out login,

then how that user can be used?

we can use :

EXECUTE AS imporuser

exec dbo.testsp

where this can be used...

thanks,

how it is useful in real time? i.e., when it is useful?

thanks,

Yes i've input and output as input 0 and output 0

thanks for your response,

Actually my question is like Difference between UPGRADE VS MIGRATION.

What exactly they do?

thanks,

hi,

thanks for your reply, but i'm not able to understand what exactly it will do? what are the advantages?. Do you have any specific links regarding this backup... with...

thanks for your reply,

what exactly the virtual server is?

But the temp table will be created in temp database right,

then how the table dropped with out issuing a drop statement.

when the tempdb will be cleared, that means i...

hey guys i found the solution,

go to run command "lusrmgr.msc" and see the specified user properties and add that user to administrator group. its working fine

Thanks for your prompt,

If both developers can have the same permissions ( i.e., single sql user), then they are doing modifications at the same time, then how can i prevent...

we can use Setup.exe from (setup folder/files) to rebuild,

but my doubt is

what happening to existing users(logins) how can we get those old logins?

i think master...

I want to know if we are using the two different objects(view and table)

then why it is taking the same execution plan.

And i found,

view_1 -- with more columns( indexed view...

hi,

Thanks for the help, But how can i use execution plan/io/profiler one by one. when to check these is there any specific rule.

Thanks,

hi,

thanks for ur response,

what is "three state logic"?

What i'm thinking is:

when we call for a stored procedure will it search for the all the sp's suppose if i have 1000 sp's, will it not affect the performance....

hi,

use the sp_makewebtask , do google on this u can solve.:-)