When I tried to do it on a view in SQL Server 2008 R2 I got this error: Msg 22931, Level 16, State 1, Procedure spcdcenabletableinternal, Line 100 Source table 'dbo.vwcustomer' does not exist in the current database. The data type of a column, parameter, or SQL variable is not supported.-789: 429BD: RETURN must be the last SQL statement of the atomic compound statement within an SQL row or table function.-20148: 429BL: A function which modifies SQL data is invoked in an illegal context.-20267: 429BM: The collating sequence cannot be used in this context.
thanks for the reply, i was able to solve the issue and puttting it over here for the future if some 1 else gets in to the same problem.
Sql Error 1474
the issue is related to the re-booting after the reboot the principal was not able to connect the server.. based on my research there are 2 steps to solve it.
Sql Server Error 1480
- re-start ur service which will bring the mirror server to (principal and synchronized state)
Sql Server Error 1474
if that doesnt work than we have to do the long process.
remove mirroring and config the mirroring again
for this these are the steps to follow.
on the mirror server since the database is set as a mirror database and showing in a restore state; change that to the regular state
for this you have to run the ALTER DATABASE <database name> SET PATNER OFF
this will bring the database in the regular state
now you have to do apply the full backup and all the trans log backups up till the last trans log backup.
i know in the books online it says just full backup and one trans log backup will do but it didnt work in my case. i had to apply full backup and all the avialable trans long backups from the principal database to the mirror database.
make sure to use the NON_ RECOVERY option and replace or overwrite the existing database option.
Error 1474 Severity 16 State 1
once that is set than use the mirror wizard and configure the database mirroring.
long process but worked like a charm for me.
Sql Server Error 1474 Severity 16 State 1
thanks for every onces help.