thank youuuuuuuu!!!!

sorry, another question, how do i get the first 8 characters?

thank you!!!!:D

thank you!! exactly what i need, just to confirm my column is nvarchar(8), then i could use your code to see which rows will not truncated if i use the...

one time thing.. exactly what i needed!!! thank you so much :Wow:

thank you!!!!!!:D

thank you!! should i set it off at the end?

SET IDENTITY_INSERT tblDistributors

OFF

Thank you so much!!!

yes it did! i scheduled a job to rebuild my indexes every sundaty at 1:00 am, another one to regorganize my indexes every week on sun at 2 am...

thank you guys!!, for what it is worth, i did look at the execution plan, and i compared both. :). One more question, i have my database properties as...

hi how can i edit this sp so i get also the percentage? and modify the alert if i have less than 10%? :crying:

thank you!, i read there is a replication monitor i was not using. there is a job called reinitialize subscription havind data validation errors failures, this sounds like it...

thank you!:P

My id_pk column is an identity column so i didn't put it in my excel spreadsheet, is there something i am missing?. :crying:

hi i tried doing this and also integration services export/import wizard, i have done it in sql server 2000 but is not working for me now i get an error...