network profile
| bio | website | |
|---|---|---|
| location | Krasnoyarsk, Russia | |
| age | 36 | |
| visits | member for | 1 year, 9 months |
| seen | May 16 at 3:35 | |
| stats | profile views | 41 |
I love SQL.
|
Apr 2 |
awarded | Nice Answer |
|
Mar 26 |
awarded | Organizer |
|
Aug 4 |
awarded | Yearling |
|
Jun 8 |
awarded | Caucus |
|
Apr 9 |
revised |
Sql Server 2008 database is suspected edited tags |
|
Apr 9 |
answered | Sql Server 2008 database is suspected |
|
Mar 30 |
comment |
Upgrade process from SQL Server 2000 to SQL Server 2012 As for 2000->2008, this way is to use the Upgrade Wizard. In your SQL Server 2000 you should run SQL Server 2008 setup and then select Planning -> Install upgrade adwizor. After install try to run it. But I didn't tryed to do it on windows 2000, maybe this method will not work. |
|
Mar 30 |
revised |
Upgrade process from SQL Server 2000 to SQL Server 2012 added 303 characters in body |
|
Mar 30 |
answered | Upgrade process from SQL Server 2000 to SQL Server 2012 |
|
Mar 30 |
comment |
How to deny drop permission for a table? If you want to restrict the DBO user right, ask about it. Your question is "Is there a way to deny drop permissions for a specific table from a user or role?". Concerning your comment: prevent DBO user from deleting object in database - bad idea, You just MUST NOT give this user DBO rights. Give him appropriate rights for appropriate objects, but not DBO. DBO is owner of ENTIRE DATABASE. |
|
Mar 30 |
answered | How to deny drop permission for a table? |
|
Mar 30 |
comment |
User Rights - Database Security logins SIDs on the servers are different, so after database restore database users cannot be mapped to logins on new server. These users called "orphaned". There is two ways to fix the orphaned users: re-map the users to existing logins (see the solution here sqlteam.com/forums/topic.asp?TOPIC_ID=12615 ) or recreate the logins from "old" server to the "new" server with "old" SIDs as I proposed in my answer. It is possible, that first solution (sp_fixusers) is more applicable for you. |
|
Mar 29 |
comment |
User Rights - Database Security see my answer how to transfer the logins with permissions from source server to destination server. |
|
Mar 29 |
answered | User Rights - Database Security |
|
Mar 29 |
comment |
User Rights - Database Security In this case I cannot see the appropriate solution, because the permissions for restore are granted on entire server level. if you give the maximum database-level permissions (I mean DBO) without server-level permissions, this DBO will not have the restore ability. |
|
Mar 29 |
comment |
User Rights - Database Security maybe the simpliest way is to istall aditional instance of sql server on the same server? |
|
Mar 28 |
revised |
Restoring a DB issues deleted 110 characters in body |
|
Mar 28 |
answered | Restoring a DB issues |
|
Mar 15 |
comment |
Tips for using DML Statements The resources for deep learning of SQL are discussed here: dba.stackexchange.com/questions/14757/… |
|
Mar 14 |
answered | What's the difference between functions and stored procedures? |
