Recent content by nowayout

there is no choice in EM when creating new table!!

Hi all, How can i change the field to make it increment automatically. such as ID field to auto increment for each entry. Thanks

i did remove all the ting but still getting the same error after that too. how can i find that in server. how do i look up on distribution database?? or what!!! help please Thanks

Hi all, I am trying to change the column with varchar instead char and add additional colum in to table but it says that it cannot be modify because the table is in replication while thereis no replication running on that table and i have deleted all the reaplication running so what is the...

i ran the reset status again but did not restarted the server but if i try to open the table then it tells me that can't open database in suspect. what is there that i can do!!

i don;t have back up of this database so can i recover this db from different db server distribution database? i am trying to clam but you know the situation now!! cuz there is no backup of this database from starting with!! what is your suggestion now!!

when i ran sp_resetstatus distribution i got this: Prior to updating sysdatabases entry for database 'distribution', mode = 0 and status = 280 (status suspect_bit = 256). For row in sysdatabases for database 'distribution', the status bit 256 was forced off and mode was forced to 0. Warning...

i tried using that option but after rebooting the server it went back to suspect again!! what is the problem and what shoud i do now!! please guide me!! totally lost now!!

will sp_resetstatus help!! what will be the implication!!or effect on rest of the database!! Thanks

prior to that ist says that an error occurred while processing the log for dabase "distribution" and prior to that also it says an error occurred while procession the log for dabase "test" which was being replicated.

along witht hat is 9004 and 9001 whihc is log for db is not available.

the error code is 3414.

the server log file also states that database 'distribution' could not recover, contact technical support!!!! please help!!!

i don;t know but i was trying to reintialize the replication agent and in between that time it went suspect status. how can i solve this please help!!!

in server log file it says that error while undoing logged operation in database "distribution" then other error saying that an eeror occurred while processing the log for database" thanks