Search results for query: *

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

How can i solve this error? Please help

ia m getting that error again after i re created the replication agent. Is there any one who can help me to solve this problem. cuz after recreating the agent it fails in about month period and then i have to recreate it. What is the problem here!! Thanks

Hi guys, How can i perform internal locking system through SQL on database rather than from frontend!!how can i perform that!!! Thanks

Hi all, Need to check what the table size after the data transfer. How can i change is and how can i increase the size of it!! thanks

Hi all, I have code written in to c++ and C# to save blob which converts whole thing in to string and save it in to database but if it is > 8K then it saves the file in to server and saves the link in to database. so if i want to save that blob in to database which takes long time and i want to...