Hi, An interesting article describing that after data warehouse is in, what should be the decision support system definition now? To read article visit this...
Hi Santhosh, If this is one time task for you, I would suggest create whole table script from EM and remove table creation code.. In script file first half is...
I upgraded myself to SQL 2005 Database Administrator (MCITP - DBA 70- 447) today. What i want to tell u all is , the Microsoft Cerification Question Pattern...
Thanks Madhu for info ! ... From: Madhu K Nair <madhuotp@...> To: sqlcon@yahoogroups.com Sent: Saturday, January 6, 2007 4:44:00 PM Subject: MUGH-SQLCON...
Hi, Complete Code on How to send email from Database in HTML format. Copy the code and run it: http://www.database-guru.com/ora_emailHTMLFormat.php Cheers, ...
Congratulations Madhu.. This is a wonderful news and Hope this information will be quite useful for all others.. Cheers veeru ________________________________...
I'm excited but nervous at the same time because I'm about to start my 2000 SQL cert. classes. Have a great day. craig ________________________________ From:...
Congratulation :) Thanks for giviing valuable information... Ved ... From: Veer Ji Wangoo <veerw@...> To: sqlcon@yahoogroups.com Sent: Sunday, January 7,...
Hi All, According To Job Setting in Database Server,Every Month 1st, SQLServer used to fullbackup and every day at 8 A.m Differential Backup. but According to...
Hi Santosh, To get the data of 10th of the previous month u **don't ** need 7th differential Backup. correct me if i am wrong (a) u have full backup of 4th (b)...
Perfect scenario to explain Back and restore phenomenon... ________________________________ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
Delete from T1; suppose that T1 is 1000 no. of records. i want to return back all records deleted by previous command without Begin tran. Is It Possible? With...
Hi Santosh, If you are using Begin Tran then it is possbile.. Best Regards Shyam Sunder .K Database Administrator. Accenture Services Pvt Ltd. 98851 33956. ......
Which version of SQL Server r u talking about. If it is SQL Server 2005, yes u can get it back without Begin tran or Restore from TL backup. In sql server 2005...
Hi All Is Passible to take only log back up and as same to restore... Is It Possible then How? after taking log backup,can i delete the contains of log files...
Hi Santosh, First let me tell you, if you really want to learn the backup architecture of SQL Server, you should try yourself with some case study in your...
Great explanation Madhu....I really appreciate… Rizwan... Madhu K Nair <madhuotp@...> wrote: Hi Santosh, First let me tell you, if you really want to...
Madhu can you please xplin this : "I will restore the full backup with NoRecovery Option and then I will restore the log earlier than the full backup taken...
Hi Manish, This is not a valid case and that is what I mentioned. I think u have missed the observation part. Nevertheless, I will repeat what I really want...
Hi Sunil, The error is self descriptive. It is the problem of Permission to the network location. If u r using windows authentication, then the user should...