Search results for query: *

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...

in windows performance monitor add counter choose sql server:general statistics u will monitor the number of connection connected to ur database

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...

i would like alter identity property to change the seed value of an existing column using T-SQL

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...

try to convert the sxbal to a numeric data type SELECT DISTINCT CAST (mx.member AS BIGINT) Member, mxstreet, mxextra, sxcntsw, ROUND(CAST(sxbal as real),2) AS sxbal, try it i think it will work

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...

look if u r using the SET ROWCOUNT n if not try : SET ROWCOUNT 0 : that will switch it off and for the update on view : use sql 2000 it is a new feature in it

look if u r using the SET ROWCOUNT n if not try : SET ROWCOUNT 0 : that will switch it off and for the update on view : use sql 2000 it is a new feature in it

look if u r using the SET ROWCOUNT n if not try : SET ROWCOUNT 0 : that will switch it off and for the update on view : use sql 2000 it is a new feature in it

you can use DROP DATABASE database_name [ ,...n ] if u r using visual basic on the ado connection the connection must be to the master database cn.execute "use master" cn.execute "DROP DATABASE database_name "