Hi everyone, Is there a statement that I use to grant to a user Maryland to select all objects in a database Banks created by me? Thanks
Hi everyone, I create a new account. sp_addlogin 'myUser','myUser',@encryptopt='skip_encryption' It means this password is not encrypted. But I...
Hi everyone, I want to recreate master by using rebuild utility. And then I will use its backup to restore. But I take a long time to rebuild...
Hi everyone, I want to use scm utility to shutdown and start SQL Server on another machine although I also know Service Manager can do too. To...
Hi everyone, I use the statement OSQL -L to see all SQL servers. But some of them don't appear in the list. Why? Thanks
Hi everyone, I have a script including several sql statements. How can I run it in osql? Thanks
Hi everyone, I set my database as follows: EXEC sp_dboption myDB,'trunc. log on chkpt.','false' It means that CHECKPOINT will not truncate the...
Hi everyone, I set autoshrink option in my database. My database contains 8 tables, each of which has at least 80,000 rows. My database size is...
Hi everyone, My database has 2 log files. Do they have the same content? If they don't have the same content, how can I switch from one log file to...
Hi everyone, I am creating a remote server by using Remote Server in Enterprise Manager. I see a option "Check Password" in both "Map all remote...
Hi everyone, How can I use a database whose log file is lost? Thanks
Hi everyone, I read from Book Online that CHECKPOINT will only truncate database's log in Simple Recovery Model. But it seems CHECKPIONT also...
Hi everyone, I just begin studying backup and restore. I read Book Online about Backup set. Backup set is the data of a backup operation. This data...
Hi everyone, I have a problem with Multi Server Administration. Only Standard or Enterprise version can create a master server, is that right?...
Hi everyone, Can I schedule my job that repeats after 3 seconds? It seems job can only repeat after 1 minute, is that right? Thanks
Hi everyone, Is there any method or statement to lock an user account? Can SQL Server lock an account if user logins 3 times with wrong passwords?...
Hi everyone, I use Enterprise Manager to kill process. But I see nothing changing until I disconnect and reconnect. Is there any method to improve...
Hi everyone, SQL Server 2000 Enterprise version can manage very large database. So how many TBs can SQL Server manage? I read from a material that...
Hi everyone, Is there a statement granting role A to role B? Thanks
Separate names with a comma.
