Why we need a group by clause?4 6450
What is the difference between referencing and joining?1 2133
What is ACID Property of Transaction?10 29469
What is a cursor in SQL Server 2000 and their types?8 13469
How do we get month name in SQL Server 2000, Oracle, MS Access?11 45295
How do we return a record set from a Stored Procedure in SQl server 2000?3 3497
How do we get current date in SQL Server 2000, Oracle, MS Access?13 42526
What are the differences between stored procedure and functions in SQL Server 2000?25 95630
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???3 3588
Which is best Subquery (or) joins in sql server? explain why2 8805
1 01 101 01010
plss anybody specify tha constrian management system in dbms
on line cluster can we make if yes tell me the procedure
System variable and temporary variables
What is Lock table in SQL?
How do use Having,Group by,Group function in SQL?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
What is the query optimization statistics?
How do you Implement SSIS Packages in your Project?
which backup strategy you are following at ur company
SQL Server Architecture ?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
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?