You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the dirty pages?
How to convert numeric expression data types using the cast() function?
What are the advantages of having an index on the sql server?
what is the difference between group and having give an example with query and sample output
What is the benefit of normalization?
List the data types available in mssql?
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.
What is the recursive stored procedure in sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com
What is Peer to peer Replication?
1 Answers CarrizalSoft Technologies, HCL,
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
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)