thank you!

sorry i edited

29

29

62

677

677

sure

now:

1900-01-30 00:00:00.000

1900-01-30 00:00:00.000

1900-03-04 00:00:00.000

1901-11-09 00:00:00.000

1901-11-09 00:00:00.000

desired :

29

29

62

677

677

the data type for the column should had been

udDistID(int,not null)

can you help?

when creating a table we made a mistake it was supposed to be an integer column and is supposed to store by default a distributer ID using a function. ...

thank you, i read in some articles that using the rebuild indexes from the maintenance task wizard is not good in prod heavily used dbs with the standard edition, is...

thank you, i read in some articles that using the rebuild indexes from the maintenance task wizard is not good in prod heavily used dbs with the standard edition, is...

what about for the future inserts into the table?, is there a way to add a constraint if the column is null when a new row is entered then set...

I had the maintenance job to rebuild but it was taking around 6 hours to run so instead I created a stored procedure to reindex/reorg based of fragmentation level and...

hi i have a related question,

i have a stored procedure which according to table fragmentation does a rebuild index to only those tables, is it necessary to run the...

thank you! i did a job with the first step to EXEC sp_publication_validation 'pubnaname', @rowcount_only=1 and second step to send notification (stored procedure that check the sysreplicationalerts table for errors)....

i have created the alert in the subscriber , can you tell me how to call it on a created job in the primary? thanks for all your help!

thank you, can i use this instructions to set it up and schedule it only to run on weekends after the alert is made?

http://technet.microsoft.com/en-us/library/ms151251.aspx

or do i have to set up...

hi again, just to confirm, i can schedule the predefined data validation for rowcounts only three times a day eventhough the transactional replication runs every 2 minutes correct? they are...

thank you!!

thanks, basically i wanted to do one as a checkup of only the rowcounts to send an alert, so i just wanted it to run like three times a...