Reputation
22,073
Next tag badge:
99/100 score
31/20 answers
Badges
2 23 52
Newest
 Enlightened
Impact
~1.1m people reached

Apr
11
comment Restoring SQL Server 2000 database to SQL Server 2008
Yes you just need to restore the user databases to the new instance and change the compatibility level if you need the higher level compatibility. There's no need to change the collation.
Mar
23
comment What permissions does db_owner not have? (In SQL Server 2008)
If you are going to downvote a correct answer, you should at least tell me why.
Mar
17
answered Restoring SQL Server 2000 database to SQL Server 2008
Mar
17
answered What permissions does db_owner not have? (In SQL Server 2008)
Mar
17
comment How to change the instance name of SQL Server Express 2008?
This has not changed and probably never will.
Feb
25
comment What is the name for a table that keeps track of operations that have been performed on the database?
Sounds like a general auditing table to me. I assume this is something that was built into your application and isn't provided by your RDBMS automatically?
Feb
16
comment how to restrict user to run sql server database only on partiular ip only?
Are you trying to make it so that users can only connect from one IP address, or does the server have multiple IPs and you only want users to be able to connect to one IP address?
Feb
15
comment Is there a reason not to use white spaces for column names?
Because spaces are the devils handy work.
Feb
9
comment Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
I said preferred, not required. For normal applications that make up 98% of the databases in the world a clustered key on an identity column works just fine.
Jan
28
answered Best way to migrate a huge SQL Server database with low downtime over network
Jan
28
comment SSMS IntelliSense doesn't work on particular database
What compatibility level is the database and what version is the server?
Jan
27
answered SQL Alert: 020 - SSPI handshake failure. Tracking the cause?
Jan
21
awarded  Enlightened
Jan
20
awarded  Nice Answer
Jan
20
answered Datawarehouse bad practice?
Jan
20
comment What is the permission needed to add permissions?
OK, I looked up securityadmin in BOL and you still have to be a user within the database to grant rights within the database. So if the user which you are using isn't inside the database, then you'll need to be sysadmin in order to change stuff within the database.
Jan
14
comment Backup and FTP SQL Server databases
I would go with option #2.
Jan
13
answered What is the permission needed to add permissions?
Jan
13
answered How do you copy a TDE-encrypted SQL Server database using T-SQL programatically?
Jan
13
comment Allow public use of functions without giving them database control
That'll work as well, as long as you are OK with them being able to execute every stored procedure and function within the dbo schema.