I have SQL Cluster with multiple instances of SQL databases
each instance have multiple databases, some of databases replicated with other servers through VPN connectivity. I want to secure the databses on this shared environment.
I want to setup replication on remote environment without...
SYSCONSTRAINTS VIEW is lost
and i managed to find the code to create the view
and created a user view with the same name .
but it is still a user view not a system view as it should
my question : is tere is a way to change the type of the view from user view to a system view ?
and if there...
hi
i used to use SQL server 7.0 and now i uninstall it and installed sql server 2000
trying to restore my settings :
whenever i try to attach the (mdf,ldf) file i got a massage :
ERROR 90033: The LSN (3580:418:1)Passed to log scan in database 'Database Name' is invalid
PS: i tried to delete...
in a merge replication
there is a column in a table on the publisher i don't want to replicate it
but i want it to be in the subscriber database
ex:
publisher Table
Field1 (want to replicate )
Field2 (Don't want to replicate )
Field3 (want to replicate )
in the...
in a merge replication
there is a column in a table on the publisher i don't want to replicate it
but i want it to be in the subscriber database
ex:
publisher Table
Field1 (want to replicate )
Field2 (Don't want to replicate )
Field3 (want to replicate )
in the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.