How to Restrict Database for One User in SQL Server 2008 R2?
Let’s learn how to Restrict Database for One User in SQL Server 2008 R2. The most accurate or helpful solution is served by Database Administrators.
There are ten answers to this question.
Best solution
It is my understanding that a user has to be a "dbcreator" in order to restore databases. However, what if I want a specific user to restore only one specific database, but not gain access or restore any other database on the server? Doesn't "dbcreator" allow that user to essentially restore any database?
Answer:
Log in as a server admin. Create a stored procedure with execute as owner that restores a particular...
Tinkerbell at Database Administrators Mark as irrelevant Undo
Other solutions
Hai everyone, I am new for SQL SERVER Administration. Nowadays i am looking for SQL Backup. I am very much confused about Differential & Transactional Log backups. Please explain me the difference step by step. Say suppose, my database name is X...
Answer:
A Differential Backup contains all changes to the database since the last Complete Backup. Transaction...
vijay at Yahoo! Answers Mark as irrelevant Undo
Are there any phpmyadmin-like tools for Microsoft SQL Server 2005, or other options to restrict direct access to SQL, but leaving productivity and functionality intact? I am currently in the middle of trying to restrict write access to the production...
Answer:
Is there anything wrong with using SQL Server Management Studio? It's a (Windows) desktop application...
mrw at Ask.Metafilter.Com Mark as irrelevant Undo
Recently our SQL Server 2008 R2 has began to stop cleaning up defunct SQL processes as show by and EXEC sp_who2. From reading I know a ghost process should run every 10 seconds and clean these process up. But when our system get busy the processes...
Answer:
If the processes are not being released because your developers are leaving connections open, that's...
Grant Fritchey at Quora Mark as irrelevant Undo
Databases: is it better to spend money on faster disk I/O or partitioned tables? Which has more influence on the speed of a SELECT query? The company I'm contracted to uses SQL Server 2008 R2 on a virtual server hosted by a data center. It's an OLTP...
Answer:
Benchmarking your I/O subsystem is always advisable to get you a baseline for performance tweeks that...
Ritchie at Ask.Metafilter.Com Mark as irrelevant Undo
I was hoping to get some assistance with the query below. I was able to create the individual SELECT statements against the Pubs database in SQL Server 2008 R2, but I am not sure how to join them as one select query so the results come up in one table...
Answer:
Don't know if this is exactly right but this is what comes to mind as a start: SELECT state, payterms...
Rob at Yahoo! Answers Mark as irrelevant Undo
i am designing a database using sql server 2008 r2. In around 90% of the tables i have added an identifier column (i set the Identity specification to Yes) that will contain an auto-generated number that can uniquely indentify the table rows. But in...
Answer:
Varchar columns make lousy targets for indexes and primary keys in particular. Remember that a primary...
Qaqaqwq W at Yahoo! Answers Mark as irrelevant Undo
I have a database table with sensitive (read as personal, non-financial) information inside our office locked-down network that I need to expose to users on a website. What's the best way for me to expose this data without exposing us to unnecessary...
Answer:
Caveat: I know nothing about Azure or Microsoft technology. Also if you're dealing with regulations...
chillin411 at Ask.Metafilter.Com Mark as irrelevant Undo
We have hundreds of report stored procedures that we are wanting to create a reporting only database and drop all columns that are not used by any of the stored procedures.
Answer:
There is no easy way to do this that I'm aware of for columns. You can pretty easily determine the tables...
Grant Fritchey at Quora Mark as irrelevant Undo
I back up the database in sql server 2008 to the file has extension ".bak". After i send it for my friends in group. He said "i can't restore the file to database in sql server 2005"? Can you help me? Thanks!
Answer:
Because they're not backwards compatable. You'd see the exact same problems if you tried to open a MS...
Ko aj ca at Yahoo! Answers Mark as irrelevant Undo
Related Q & A:
- Can I create a second filestream container on an existing SQL Server 2008 database without going offline?Best solution by Database Administrators
- Does it ever make sense to use RAM Disk to force RAM allocation for tempdb with SQL Server 2008?Best solution by Database Administrators
- How to add primary key from multiple table as a foreign key in a table in sql server 2008?Best solution by stackoverflow.com
- How to restrict access to a sql server database from Azure?Best solution by Stack Overflow
- How to enable remote connections in SQL Server 2008?Best solution by Server Fault
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.