Thanks Jurgen. But if I'm not wrong this command will script the roles : sp_addrole..... The kind of script I would like to obtain would look like : if not exists (select * from dbo.sysusers where name = N'xxxxxx' and uid < 16382) EXEC sp_grantdbaccess N'xxxxxx', N'xxxxxx' GO exec sp_addrolemember N'db_datareader', N'xxxxxx' GO exec sp_addrolemember […]
2003-06-06
try this oserver.databases("dbname").DatabaseRoles("rolname").Script you could use this in a loop
2003-06-06
Thank you very much. How about when the database is running in simple recovery model? Will the transaction log being trunacted after Full database backup?
2003-06-05
1 reads
Thanks. I am aware of the sp_password option. However you mentioned the application. If this is the way it needs to be done. How do you integrate this into the application side where the user is prompted to change it..?
2003-06-04
1 reads
Please do not cross post. See/leave responses in Moderator please handle this thread.
2003-06-04
You can use the sp_resetstatus system proc. That will try to force the database online/healthy. You have to stop/start the server to take affect, which may be a problem from what you said. ...If that doesn't work, you can force the DB into emergency mode by setting the "status" field for that DB in sysdatabases […]
2003-05-29
1 reads
The example I gave was not the best in that it immediate brought up questions of why I was trying to generate the key in that way in the first place. The situation is more one of coming into a place where they keys are generated in this way, but for each table and I […]
2003-05-22
2 reads
I'm thinking of implementing centralised validation of input at a database level for protecting against sql injection. I do not trust this only be done at application level. Nested stored procedures might be a way to do this. Any thoughts on this? Cheers, Frank
2003-05-22
1 reads
Are you using Windows Authentication, SQL authentication or mixed mode?
2003-05-21
table_pk is the primary key constraint name. In this case they are using the table name plus "_PK" to make up the name. Therefore if your table was called tblEmployee, the Primary key of that table would be "tblEmployee_pk" using their format. If a constraint name is not specified, the database will automatically generate one […]
2003-05-15
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers