1,226 reputation
139
bio website
location Krasnoyarsk, Russia
age 37
visits member for 2 years, 8 months
seen Mar 31 at 1:42

I love SQL.


Aug
4
awarded  Yearling
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/…