Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?1 4190
What is BCP? When do we use it?2 7997
What should we do to copy the tables, schema and views from one SQL Server to another?3 6001
What are the different types of joins and what does each do?2 5839
What is a sub-query? When would you use one?3 10990
What are three SQL keywords used to change or set someone?s permissions?3 11607
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?5 12400
What is a trigger?7 4206
What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?2 9656
What is an execution plan? When would you use it? How would you view the execution plan?1 4113
What does it mean to have quoted_identifier on? What are the implications of having it off?2 8082
What are the different types of replication? How are they used?3 9108
What is the difference between a local and a global variable?5 33860
How do you Implement SSIS Packages in your Project?
How can we call UDF(User Define Function) using C# code in ASP.net ?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
New concepts of sql server 2005 use in your project.
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Call by value and call by reference in procedure and function, with NOCOPY.
wat wil hapn if we give the both read and deny read permission to user?
where the connection string store in the database
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
What is RMS migrations?
Delete duplicate rows without using rowid.
Tell about MOM Tool(Microsoft Operator Manager)?
how can you attach more than 20 ldf files in sql server
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?