Thank all of you. I will try db_datareader.
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
I think when I enter password into dialog "Connect to SQL Server" in Query Analyzer, this password is encrypted and then matched with password in...
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...
Thank Ghemant.
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...
Yes, stored procedure is a good idea. In fact, I only want to know there is a statement that can do so. Because in Oracle, I can do by using:...
Maybe you don't understand my idea. I can run by: C:osql -E -i C:math.sql But I don't know how to run when I am in osql. 1> Thanks
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
This database is created only to test autoshrink option.
If transaction does not finish, CHECKPOINT will still truncate the inactive log no matter what 'trunc. log on chkpt.' option is false or true.
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...
What a pity! I still can not access it. I check properties by right clicking my old and new data file. And I find out that their times are...
No, my database has one data file. I create a new database whose name is the same as my old database. And then I shutdown my SQL Server. I delete...
Separate names with a comma.
