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...
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 ...
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...
how come sa will remove , if already you have dropped buildin\Administrator.. very surprising .. ... From: kunal choudhary <nitin_mca_23@...> Subject:...
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...
I hope NTauthority is still there. you can connect with account with SA permissions. Thanks -Virender M. MS, MCDBA, MCITP ... From: kunal choudhary...
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...
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...
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...
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 ...
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...
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...
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 ...
Hi Shyam,    It should be a straight forward thing.    If you are changing from simple to full recovery    1. Change the recovery model. ...
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...
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...
Hi Shyam, its not possible to bring into sync if we miss one log file... we have to do bcr compulsory.... Rgds anand ________________________________ From:...
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 ...
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...
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. ...
Hi, 1. Restore the friday full database backup with no recovery option 2. Next Restore the last differential backup (Wednesday) with recovery option Regds ...
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...
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...
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...