Hi, Can I convert timestamp value to current time values? when I convert select CAST (0x00000000000067FB as datetime ) it giving me oudated values...
Hi, I would plan to migrate my db to another server, current configuration with only Primary & indexes file group exits in the db and now I want to...
i GIVING TRY as below statement update i set packid = b.packid, deckid = b.deckid from individual i inner join port b on i.msn = b.msn where...
Hi, below is my sql statement that wil join and update the values, but it giving me error Ambiguous column name both table hold the same column...
I wanted to know how do we replicate the new table from publisher to subscriber.. I know how to add/drop column... so is there any way that i can...
Rerun the snapshot but it does not replicate the new table. Last action msg: A snapshot was not generated because no subscription needed the...
Hi.. I would like to know what would be happen if I just simply add/drop the column in repld db??? Or If I have added extra tables/column in...
It works.. thanks...
Hi.. One more error prompt by windows during setting up the Publisher. Error 20028 The Distributor has not been installed correctly. Could not enable...
Hi. I managed to solved the problems, It was bcoz the C drive was not shared so I created the share for the drive an now I able to create the...
Hi.. I'm trying to setup the replication distribution database. In specify Snapshot folder windows, it giving me error my path/folder 'Is not a...
Hi.. Yes I do have setting as what u've mentioned On success Action : Quit the job reporting success On failure Action : Quit the job reporting...
Can you check SQL job->step->Advanced->'On success Action' for your database backup job.. Someone may have incorrectly mentioned to "Quit the job...
Hi.. I did run my Db full backup for everyday, the jobs shown failed, but the backup file was created. I did checked in the backup job history and...
Separate names with a comma.
