I have an app that is running against the sqla but soon unfortunately we will move it to run against the sql server. There is a query in sqla that gets current publisher from dummy baiscally this is what it is:
select current publisher from dummy ;
this returns DBA when I run it against my sqla db, however the query would not run against sql server, does anyone know what the comparable query is in sql server? or should I ask this in sql server forum? Any help would be great.
There isn't a compatible query in MS SQL Server (or ASE). The "current publisher" is a database user in the local database thta is used to uniquely identify the database in a SQL Remote replication system. SQL Remote only runs against SQL Anywhere, so the query is specific to SQL Anywhere.
answered 20 Sep '12, 13:39