Hi All, The server is in mixed mode authentication. we have removed Builtin Administrators account and sa has been removed. how can we reset the sa password...
6203
kunal choudhary
nitin_mca_23
Oct 1, 2008 9:25 am
Try to connect SQL Server with windows login and then go to change SA password. Nitin ... From: Shyam Sunder <shyam_k25@...> To: sqlcon@yahoogroups.com ...
6204
jacob.sebastian
Oct 1, 2008 11:43 am
I shared with you a few posts, last week, discussing recursive updates in SQL server. We discussed the example of an ecommerce application that needs to...
6205
rakesh kumar
hisinha_rakesh
Oct 1, 2008 3:21 pm
how come sa will remove , if already you have dropped buildin\Administrator.. very surprising .. ... From: kunal choudhary <nitin_mca_23@...> Subject:...
6206
jacob.sebastian
Oct 2, 2008 11:15 am
You must have noticed that I kept posting about recursive updates several times in the last few weeks. This is the last post in the series that demonstrates...
6207
virender mann
virenmann
Oct 2, 2008 5:12 pm
I hope NTauthority is still there. you can connect with account with SA permissions. Thanks -Virender M. MS, MCDBA, MCITP ... From: kunal choudhary...
6208
jacob.sebastian
Oct 6, 2008 4:03 am
SQL Server - Recursive CTE and Ordering of Hierarchical Result WE discussed Recursive CTEs in many of the previous posts. Most of the times we use a recursive...
6209
jacob.sebastian
Oct 8, 2008 4:53 am
Many of you must have found the OBJECT_ID() function very handy. It is particularly helpful to check the existence of an object. SQL Server 2005 added a second...
6210
jacob.sebastian
Oct 17, 2008 6:24 am
SQL Server SET Options, XQuery Labs and System Catalog Views I wrote a few SQL Server blog posts this week and I thought some of you might find them...
6211
Shyam Sunder
shyam_k25
Oct 17, 2008 11:15 am
Hi all, we are executing DBCC CHECKDB and symultaniously some DML transactions are running. any side effects for sql server... Best Regards Shyam Sunder .K ...
6212
Veer Ji Wangoo
vwangoo
Oct 17, 2008 1:49 pm
Not advisable but wont damage ... From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of Shyam Sunder Sent: Friday, October 17, 2008 4:45 PM...
6213
virender mann
virenmann
Oct 19, 2008 5:59 pm
It depends where the DML tracnsactions are running. No Problem at all if it is SQL 2008/2005 but will take more time. Also it may fail if FILESTREAM data is...
6214
Shyam Sunder
shyam_k25
Oct 19, 2008 7:12 pm
Hi All, If we are changing the database recovery model then what are the steps / precaution we need to take. Please guide me... Best Regards Shyam Sunder .K ...
6215
Santhosh
san_spy
Oct 19, 2008 11:38 pm
Hi Shyam,    It should be a straight forward thing.    If you are changing from simple to full recovery    1. Change the recovery model. ...
6216
s manikanth
s_manikanth
Oct 20, 2008 3:37 pm
I think DBCC commands causes shared locks internally, thats why they introduced DMVs, DMFs. thks, Mani ... From: Veer Ji Wangoo <veerw@...> Subject: RE:...
6217
Madhu K Nair
madhuotp
Oct 20, 2008 5:11 pm
Changing Recoverymodel is more significant in SQL Server 2008. To truncate TL in 2008 you need to change the Recovery model to Simple and then Shrink. Backup...
6218
Shyam Sunder
shyam_k25
Oct 21, 2008 3:26 pm
Hi All, We have implemented log shipping and working fine. but unfortunately we lost one log backup file in Primary server. with out doing the BCR (Backup Copy...
6219
Anand Kumar Reddy
anandkreddy
Oct 22, 2008 1:39 pm
Hi Shyam, its not possible to bring into sync if we miss one log file... we have to do bcr compulsory.... Rgds anand ________________________________ From:...
6220
Shyam Sunder
shyam_k25
Oct 22, 2008 7:55 pm
Hi All, Any architectural change in log-shipping between SQL Server 2K and SQL Server 2K5? Please give your inputs on this. Best Regards Shyam Sunder .K ...
6221
Shyam Sunder
shyam_k25
Oct 23, 2008 7:04 am
Hi All, if we have a differential backup then is it possible??? Best Regards Shyam Sunder .K Database Administrator. 98851 33956. ...
6222
kunal choudhary
nitin_mca_23
Oct 23, 2008 7:50 am
Differential will not work for this. You have to go with bcr. Â ________________________________ From: Shyam Sunder <shyam_k25@...> To:...
Convite pessoal de Bruno Carbone Gonçalves [Non-text portions of this message have been removed]...
6225
kanchan verma
kanchanvrm
Oct 31, 2008 10:23 am
Suppose I have taken full backup on friday and increment on monday, tuesday and wednesday then how to restore the backp  regards   Add more friends to...
6226
Santhosh
san_spy
Oct 31, 2008 11:41 am
Hi, 1. Restore the Last full backup 2. Restore the latest increment backup. 3. Restore the transaction log backups taken after that last incremental backup. ...
6227
Anand Kumar Reddy
anandkreddy
Oct 31, 2008 2:23 pm
Hi, 1. Restore the friday full database backup with no recovery option 2. Next Restore the last differential backup (Wednesday) with recovery option Regds ...
6228
kanchan verma
kanchanvrm
Nov 6, 2008 4:40 am
can u give with syntax so that it will easy for me to understand  regards ... From: Santhosh <san_spy@...> Subject: Re: MUGH-SQLCON Re Restore To:...
6229
Shyam Sunder
shyam_k25
Nov 6, 2008 7:05 am
Hi All, what is the mechanism litespeed will follow while taking the backup. how the size will be less and performance is more compare to sql server normal...
6230
virender mann
virenmann
Nov 6, 2008 8:29 pm
SQLÂ Server 2008 has much lesser size and performance is better than lite speed. Compression ration is higher than lite speed if you define the compress option...
6231
Bruno Carbone Gonç...
overload_mail
Nov 7, 2008 6:08 pm
Olá, Em 10/24/2008 12:54:03 PM, Bruno Carbone Gonçalves lhe pediu para fazer parte do seu caderno de endereços Unyk para ter sempre acesso aos seus dados, e...