Forum Replies Created

Viewing 3 posts - 16 through 18 (of 18 total)

  • RE: SQLCMD Problem

    take out the " "

    FOR /F ["options"] %variable IN (file-set) DO command [command-parameters]

    FOR /F ["options"] %variable IN ('string') DO command [command-parameters]

    FOR /F ["options"] %variable IN (`command`) DO command [command-parameters]

    for example

    FOR...

  • RE: Deattach or take offline the DB to copy

    ALTER DATABASE YourDB SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

    ALTER DATABASE YourDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    Or this will do the job. Sorry about the cursor, an old script but you...

  • RE: How to give dbo_access to a user on a database?

    1) How to give dbo_access to a user?

    sp_rolemember 'db_owner','username'

    or sp_changedbowner 'username' (if you like)

    2) What is the use of schemas?

    Enable more granular security within a database. You can assign right...

Viewing 3 posts - 16 through 18 (of 18 total)