SQLTeam.com | Weblogs | Forums

Database copy from 12.0.5 to 11.0.3

ssms

#1

Hi

I have copied database created in 12.0.5 SSMS dev environment to 11.0.3 SSMS production via sql command . Schema and data both copied correctly . I login to ssms 12.0.5 and connect to Prod DB but when i am trying to create new trigger via UI the option 'New Trigger' appears disabled.Any idea how to fix the problem though i am able to create new trigger when i log in to DB on SSMS 12.0.5.

Thanks
Shilpi