Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
No Answer is Posted For this Question
Be the First to Post Answer
How to change the system date and time from SQL Plus Terminal ?
How do I view a procedure in sql server?
Do you know what are the restrictions that views have to follow?
What command do we use to rename a db, a table and a column?
How can you get @@error and @@rowcount at the same time?
What is the New in SQL server 2008?
What are the joins in sql server? : sql server database administration
What are recommended options to be used while using db mirroring? : sql server database administration
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is model database in sql server?
What are window functions in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)