how you can move data or databases between servers and databases in sql server? : Sql server administration
No Answer is Posted For this Question
Be the First to Post Answer
If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?
what is package configuration variable?How to change file name in folder dynamically?Plz help me
my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What is a livelock?
What is logshipping and its purpose?
What is a rollup clause?
How do I edit a procedure in sql server?
How do you create a clustered index?
How to drop an existing user defined function in ms sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
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)