Hi Deepak, i have the same problem as Chaks but i have to read the flat file from ftp and then i have to insert data into sql server 2000. can you suggest...
Thank your very much radhye.Thanks a lot . i did not get answer since last 2 days. thanks a ton the problem get solved rupesh Veer Ji Wangoo <veerw@...>...
Hi All, As per recent observations by many of the SQLCON members and core team, we would like to make few requests to the SQLCON members to manage the quality...
Great Deepak. I appreciate you for giving credits to the original author. Hope everyone will follow this simple practice :) Regards Roji. P. Thomas ...
Hi I need to study performance of a sql instance and submit my recommendations 1)Is there any document or links steps to be followed in analysing sql server...
Vijay, http://www.extremeexperts.com/SQL/Articles/SQLCounters.aspx would be a nice place to start with. They have given some good description of most of the...
Hi, We are having a very high transaction server. We dont care about the data loss but we need fast insertion. Currently the database is under simple recovery...
Gr8 deepak its really nice work around. regards kumanan "Roji. P. Thomas" <thomasroji@...> wrote: Great Deepak. I appreciate you for giving credits to...
Hi Team, I have installed SQL 2005 Reporting service on one of our production server. When I trying to open report manager, getting below error after...
Santhosh: I would suggest look at the DISKIO requirments part for your database to process efficiently. How you have configured and placed your database files...
Hmmmm this is very generic error message... can't relate it for single solution. Can you tell us: What is the OS version and service pack? Have you applied SP1...
Hi Deepak, Thanks for your quick reply. Yes, you are right. I have checked many article, but not getting suitable soluation. I am using Windows server 2003 EM...
Can you please post the lastest reporting service's log file which is under the: "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles...
Well I feel that recovery simple is ok in your case But just read through BOL you will come tom know loads of things about it ... Also if you are looking for...
Hi: This is not a very new bug, it was first reported to MS on April 18, 2006 by Skiwi. Bug status is still active... hopefully in next service pack of hotfix...
... Since you mentioned that, here is a humble attempt. NOTE: Before running this query, you should set the dispaly mode to text and Results font to a fixed...
Its Super o Super..How do you go about with this .. am really interested in knowing .. My head goes around and around on how do you do this .. If you can share...
Ha haah hey I need a river in this.. I tried but somehow House collapsed because of that :-):-):-) As a line in longhorn mktg at MS would say "Give me...
Hi all, Please send me sql server 2000 script to send emails through database. i tried using CDONT's and SMTP mail but i m not getting.. Plz... send me Thanks ...
Hi all, a log backup file has been deleted or not generated during log shipping. Files has been created before and after that file. how can i recover if it is...
Hi all, a log backup file has been deleted or not generated during log shipping. Files has been created before and after that file. how can i recover if it is...
You can check out details from MSDB..log_shipping_plan_history details. Another confirm the sequence of transaction log backups from SQL Server error log...
Hi: You can send Emails from MS SQL Server 2000 using below SQL command.. EXEC xp_sendmail @recipients = 'someone@...', @message = 'I am on holidays,...
Thankz Deepak, I already idetified that a backup log file is missing. now how can i over come from it. one option is i can re build log-shipping, but it will...
Can you give us the Error log information.. error log details Thanks, Deepak kumar MVP, MCDBA - SQL Server http://www.forum.sqlknowledge.com Disclaimer: This...
Deepak ill give u the details after 1 hour. i tell u whats happening . back of transaction log is being done properly as per schedule. but somewhere in middle...