Hi Can i get a command to read fronm ldf file which transactions were done regards Madhu K Nair <madhuotp@...> wrote: You may download it from microsoft...
Hi Can i get a command to read fronm ldf file which transactions were done regards ... Download prohibited? No problem. CHAT from any browser, without...
No you cant get useful information from TL using TSQL Command. There are few undocumented dbcc command but it will not help much. As already mentioned there...
Ahhh...not again...couple of questions for you. 1. Are you trying to create job on server from a SQL client (i.e. remote management studio or query analyzer)? ...
Hi Madhu, How CDC will be helpful in Kanchan's case when we really don't know what and why she need to read log files? Kanchan, Tell us the exact requirements...
Hi, What i meant to say was, why he or she need to read the TL? It may be for auditing / or to find malpractice or to get the data back which was wrongly...
How to update visual studion 2003 to 2005 regards ... Explore your hobbies and interests. Click here to begin. [Non-text portions of this message have been...
i do have sql 2000 only Kuldeep Chauhan <mrkuldeepchauhan@...> wrote: Hi Madhu, How CDC will be helpful in Kanchan's case when we really don't know what...
Madhu, I was talking form SQL Express client tools point of view, if client tools are having any conflict then this issue is reported, upgrading Express to SP2...
Reading transaction log is not a general practice otherwise Microsoft would have already provided a built in tool for this, though there are tools provided by...
Exactly we would like to know who has acessed our database and viewed the result through rollnumber..... lets say table name is xyz then who has acessed the...
Hi Kuldeep, Somehow misread the post, when i realised that i deleted the reply also. I am not sure how you got that. Madhu ... client tools are having any...
Hi Kuldeep, If you see my first post I never said TL reading is a general practice ( but I do believe it's a genuine requirement, I can quote 100s of threads...
Bingoe.....so this is your requirement.....in SQL Server 2000 there are three straight forward ways to do this but both will have some affect on performance. ...
Hi! I'm wondering if anyone could tell me if it's possible to delete the data from an specific table without registering the transaction on the SQL ...
You could change the data recovery model to simple ,then later you can revert it back. if locking is the concern you can use NOLOCK hint. Gigme. "Bruno a.k.a...
It's already on simple but it's still logging... In an Oracle database you can use: /*+ nologging */ There's something similar on MS-SQL 2000? Tks ... ...
r u pretty sure that in simple mode its still logging? Can you tell me how did you find this out? With :))s Santhosh T&H - Innovation Lab Karapakkam, Chennai ...
In simple mode it will be logging, but it will automaticaly truncate those logs, so log file does not grow much and nobody can backup those log files. if you...
Truncate table TableName is the best option. But be aware of the limitation of Truncate command Truncate Reset the identity You cannot use TRUNCATE TABLE on...
Ok, thank you all! I thought I could stop the transaction logging like I can do on Oracle. But thanks for all the info! ... [Non-text portions of this message...
Hi, I am using sql 2005 analysis services and I have deployed the cube for adventureworks. I have asround 12 dimensions but when I browse the cube only 5...
Hi Biswajit, There are two possibilities in your scenario, let me discuss them step by step here. 1. Are you able to see all 12 dimensions in BIDS of cube...
Hello All, I want to setup Database Mirroring in Workgroup environment not in domain. I am using SQL Server 2005 Statndard Edition+SP2. Can any one provide me...
Hi All, Is it possible to kill the SQL Agent job forcefully. Because on production server its not possible to restart the sql serverice. Some of sql jobs used...
If you kill a process (from Management studio or using t-sql KILL ) system has to rollback the transaction to get the database into a consistant stage. There...
Dear Deepak, we also faced the same issue on sql 2000 and solved by restarting sql agent. Best Regards Sunil John ... From: Madhu K Nair <madhuotp@...> ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
