hi i had checked both of the connections n they r enabled .. Since i m on windows 2000 it does not show Security configuration in MSDTC . Do i need to change...
hi i had checked both of the connections n they r enabled .. Since i m on windows 2000 it does not show Security configuration in MSDTC . Do i need to change...
Does this help? http://support.microsoft.com/default.aspx?scid=kb;EN-US;306843 Regards Roji. P. Thomas http://toponewithties.blogspot.com ... From: amit jain ...
Ved, You can run KILL [spid] WITH STATUSONLY to get the progress report of an SPID being rolled back. It will tell you how much percentage of the ROLLBACK...
Hi Koushik, There is no error message attached (In fact you can't send attachments to a yahoo group). Please paste the error message in the message window...
My 2 cents. Roji told the correct way to see the progress report of rollback thru Kill statement. Thanks, Kuldeep Thomas Roji <thomasroji@...> wrote: ...
Hi Kuldeep, Thank you for your quick response. The error says: "SQL server 2005 setup has dected incompatible components from beta version of Visual...
hi Akhil, You have configured the Transactional Replication on - 26 Feb Then the stand by server was getting updated and it means the configuration was...
Hello Roji ,Actually this article requires to change me the firewall configuration but i dont think my client will allow me to play with his firewall setting...
It's because some of the beta componets are still existing in your machine, though nothing is visible on "Add/Remove programes list". You need to clean them up...
Hi, We are pulling data from a source which has the collation as Japanese_CI_AS_KS_WS to our data source which has the collation as Japanese_CI_AS Though we...
Hi I like to know whether there is any method to read transactional log file using script or store procedure or sql command to read . Generally third party...
HI We have a DBCC cmd DBCC log (Databaseid)... You can refer to BOL for more details on DBCC log cmd. regards Manish Singhal vjsekars <vjsekars@...>...
hello, i am anirudh,when i am installing sql server 2000 on os which is xp sp2 an error is pooping up i.e, An error occurred while creating one or more...
Hi All, Any one know about Journaling. I Know only that journaling use to protect data from loss. I have some few question on Journaling if any one have...
It is regarding Replication Implementation... I am trying to Implementation replication on a SQL Server database, but server name is apearing in Enterprise...
Vir, when i tried to do the replication i faced the same problem. I just unregistered the LOCAL and registered it under the SQL Server name i.e. SQLMAIN,...
Hi Anirudh, I'd suggest you to do the following the same order, though I believe the 3rd point alone could solve 1. Can you verify that you have admin...
Vir, I'd tell you the same as what Akhil has told. We encountered the same problem & we had to delete the registration (local) & re-register with the server...
udhay, You can store image data image data Type. But you might be thinking how to store it exactly for a image file? You can not directly insert the image...
Hi If we use DBCC command we will be getting details of lsn number and transaction details in system code which we will not be able understood Thanks ...
thats fine, i too had similar kind of practice in my past on client machines but here I am working on Server it self, I am accessing it with my own login &...
Hi freinds, I need help from u guys in saving the image path in database using sql server and .net. I have an interface which has a browse button and a save...
Hi Friends, I have a firstName, MiddleName and LastName columns. The Middle Name is optional. In middle name for some rows there are no value (blank) - not...
i want to perform sum operation on coloums in diffrent tables. i m describing what i need exactly. There r 4 tables and i hv a date coloumn in each table but...
upto my knowledge , Journaling is not an in-built feature. Its a seperate software which supports with different data sources. for this we need to go for third...
Hi All, how to clear the *deleted *table from sql server 2000 memory ? I require this to set an audit to capture the updates done in the DB. I have written an...
Hunter, You done have to *shoot* the tables to clear them from memory. The deleted and inserted tables have scope only in the trigger level. Once you have done...
