cancel
Showing results for 
Search instead for 
Did you mean: 

current publisher in sqla and sql server

Former Member
2,712

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

regdomaratzki
Product and Topic Expert
Product and Topic Expert

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.