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

Restrict SQL Server 2008 R2 User to restore only one database (but not others)

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...

Read more

Tinkerbell at Database Administrators Mark as irrelevant Undo

Other solutions

I am having doubt in SQL SERVER 2008 R2.?

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...

Read more

vijay at Yahoo! Answers Mark as irrelevant Undo

How do i restrict access to MSSQL 2005?

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...

Read more

mrw at Ask.Metafilter.Com Mark as irrelevant Undo

How do I get SQL Server to resume cleaning up SPIDs?

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...

Read more

Grant Fritchey at Quora Mark as irrelevant Undo

Increasing database performance for SELECTs

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...

Read more

Ritchie at Ask.Metafilter.Com Mark as irrelevant Undo

Help with basic SQL SELECT Statement?

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...

Read more

Rob at Yahoo! Answers Mark as irrelevant Undo

Auto-generated primary key Versus user defined primary key?

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...

Read more

Qaqaqwq W at Yahoo! Answers Mark as irrelevant Undo

What's the safest way to get this data to the outside?

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...

Read more

chillin411 at Ask.Metafilter.Com Mark as irrelevant Undo

Where is a script to list all tables/columns in a SQL Server 2008 R2 database that are not referenced in any stored procedure?

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...

Read more

Grant Fritchey at Quora Mark as irrelevant Undo

Why do i can't restore database in sql server 2005 from the database in sql server 2008?

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...

Read more

Ko aj ca at Yahoo! Answers Mark as irrelevant Undo

Find solution

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.