Viewing 3 posts - 16 through 18 (of 18 total)
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...
July 27, 2009 at 7:46 am
#1030496
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...
July 27, 2009 at 6:35 am
#1030457
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...
July 24, 2009 at 10:24 am
#1029855