Friday, September 23, 2005

mdf den db kurtarma

EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\mssql7\data\pubs.mdf',
@filename2 = N'c:\mssql7\data\pubs_log.ldf'

sonra
burda da db yi single user moda aldım da satırı unuttum
use master
go
spdboptions 'dbadi','single user','true' gibi biseydi
go
DBCC CHECKDB ('db_Adi',REPAIR_REBUILD)
go

aslinda mdf saglam olsa son check islemine gerek kalmazdi heral ama neyse bi nebze kurtuldu oteside allah kerim :)

odd string diff

 https://leetcode.com/problems/odd-string-difference/ Beats 19.92% of users with Java   class Solution { public String oddString ( S...