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...
2822
amit jain
amitmljain
Mar 1, 2006 8:31 am
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...
2823
Roji. P. Thomas
roji_pt
Mar 1, 2006 8:55 am
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 ...
2824
Thomas Roji
roji_pt
Mar 1, 2006 3:39 pm
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...
2825
Kuldeep Chauhan
mrkuldeepcha...
Mar 1, 2006 5:22 pm
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...
2826
Kuldeep Chauhan
mrkuldeepcha...
Mar 1, 2006 5:27 pm
My 2 cents. Roji told the correct way to see the progress report of rollback thru Kill statement. Thanks, Kuldeep Thomas Roji <thomasroji@...> wrote: ...
2827
koushik roy
koushikroy_2001
Mar 2, 2006 1:33 am
Hi Kuldeep, Thank you for your quick response. The error says: "SQL server 2005 setup has dected incompatible components from beta version of Visual...
2828
Madhu K Nair
madhuotp
Mar 2, 2006 3:49 am
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...
2829
amit jain
amitmljain
Mar 2, 2006 5:11 am
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...
2830
Senthil Kumar T R
trsenthilkumar
Mar 2, 2006 8:08 am
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...
2831
Meiyalagan.B
softalagan
Mar 2, 2006 10:56 am
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...
2832
vjsekars
Mar 2, 2006 2:10 pm
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...
2833
manish singhal
manish_hce
Mar 2, 2006 2:32 pm
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@...>...
2834
anirudhworld17
Mar 2, 2006 4:31 pm
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...
2835
ved_17in
Mar 3, 2006 9:32 am
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...
2836
virender jain
virender_jain77
Mar 3, 2006 11:29 am
It is regarding Replication Implementation... I am trying to Implementation replication on a SQL Server database, but server name is apearing in Enterprise...
2837
Akhil mahajan
dabubcet
Mar 3, 2006 1:18 pm
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,...
2838
udhays21
Mar 4, 2006 4:36 am
Hi all, I need to know how 2 insert the image data type in the table. pls expalin me with the example. with regards Uday....
2839
Senthil Kumar T R
trsenthilkumar
Mar 4, 2006 4:38 am
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...
2840
Senthil Kumar T R
trsenthilkumar
Mar 4, 2006 4:51 am
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...
2841
smart chip
knowledge_chip
Mar 4, 2006 6:06 am
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...
2842
vjsekars@...
vjsekars
Mar 4, 2006 5:57 pm
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 ...
2843
virender jain
virender_jain77
Mar 6, 2006 4:53 am
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 &...
2844
aravind
gotobestfriend
Mar 6, 2006 5:12 am
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...
2845
bhavesh prajapati
bhavesh2984g...
Mar 6, 2006 5:27 am
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...
2846
nitin kumar
tanu_22781
Mar 6, 2006 6:17 am
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...
2847
Ravi Shankar
sqlravishankar
Mar 6, 2006 6:50 am
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...
2848
virender jain
virender_jain77
Mar 6, 2006 6:58 am
Nitin As dicussed on phone do like this make changes if there is any missing and or ,'' etc. Step 1. select a.run_date, a.rejection as Rejection1, ...
2849
sql hunter
rahul_mulay
Mar 6, 2006 7:14 am
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...
2850
Roji. P. Thomas
roji_pt
Mar 6, 2006 7:41 am
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...
