Ping Kwan
Friday, November 5, 2010
Re-Associate the dbo to sa login after db restored
You could use the following SQL script to relink the dbo user of a db to login.
ALTER AUTHORIZATION ON DATABASE::[db name] TO [login name]
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Search This Blog
Labels
.NET
(3)
.NET 4.0
(1)
Active Directory
(4)
Ajax
(1)
APS.NET
(1)
ASP.NET
(4)
Cache
(1)
Compression
(1)
Cryptography
(1)
Database Mail
(1)
DTA
(1)
EISA Configuration Removal
(1)
IIS
(5)
LDAP
(1)
Mime Type
(1)
NtdsUtil.exe
(1)
Page Life Cycle
(1)
PDF
(1)
Performance Problem
(1)
RadGrid
(1)
RadSpell
(1)
SDS.AM
(1)
SQL 2005
(7)
SQL 2012
(2)
Telerik
(2)
Thread
(1)
Tool
(1)
UNC Share
(1)
Web Farm
(1)
Windows 7
(1)
Windows Backup Utilities
(1)
Blog Archive
►
2013
(2)
►
March
(2)
►
2012
(3)
►
June
(1)
►
May
(2)
►
2011
(7)
►
November
(1)
►
October
(2)
►
May
(2)
►
April
(1)
►
March
(1)
▼
2010
(9)
▼
November
(2)
ASP.NET with SQL 2005 Cache Dependence
Re-Associate the dbo to sa login after db restored
►
October
(2)
►
March
(1)
►
February
(4)
►
2009
(8)
►
November
(1)
►
September
(1)
►
June
(3)
►
May
(3)
About Me
Ping
View my complete profile
No comments:
Post a Comment