You will either need to install 2008 R2 and then attach the database to that, or get a script of all the objects and exported copies of all the data...

No triggers at all in the database....

Thanks.. Is it possible to find the collation only for varchar fields???

Thank you so much again

Yes...

I created the user in the database, so the user has just the connect permission and no other permissions for this user..

Approle is granted control...

Thanks.

But when I create a user in the database and login as that user I'm able to run execute the sp_setapprole without granting execute on the application role.....

Thanks Lowell

Thanks Steve.

Sorry got the answer. I need to use substring(expression,start value,length) Thanks

Thank you so much..

I'm executing this as a dynamic sql in a procedure. I'm trying to see the dynamic build sql by 'print @sql' but when I create the...

Thanks.

DECLARE @cookie varbinary(8000);

EXEC sp_setapprole 'test', 'password1'

, @fCreateCookie = true, @cookie = @cookie OUTPUT;

Command(s) completed successfully.

Then when I execute sp_unsetapprole in the same...

Thanks Steve.

I use exec sp_setapprole to adopt the role in a session. Just wanting to know if there is a command to unset the approle from a session or...

Thanks. But, actually the application needs full control(alter,insert,delete,execute, select,view definition etc). of all the database objects (like tables,views,stored procedures,functions,triggers,symmetric keys etc).

And I get this for grant all 'The...

When I run drop application role testrole, I get

Msg 15284, Level 16, State 1, Line 1

The database principal has granted or denied permissions to objects in the database...

Sorry, I found the problem. I need to use [UCX\user1]

I got it to work.. But I'm having a different problem now..

create APPLICATION ROLE test WITH PASSWORD ='password1' , DEFAULT_SCHEMA = dbo;

EXEC sp_setapprole 'test', 'password1'

I'm able to create...