adspace


how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server.

Answer Posted / samar

plz explain in brief,

if u can send me screen shots for process , it ll be good
for undetstandin
mail id: summer_sinha@yahoo.com

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should you use or avoid select * statements?

1109


Why and when do stored procedure recompile?

1060


Explain system functions or built-in functions? What are different types of system functions?

1065


How can I check that whether automatic statistic update is enabled or not?

1112


Can one drop a column from a table?

1089


Disadvantages of the indexes?

1223


How to provide default values to function parameters?

1258


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

2295


Where can you add custom error messages to sql server?

1210


What is temporary table in sql server? Why we use temp table?

1020


How do I find the sql server version?

1102


What are different types of constraints?

1001


How to convert character strings into numeric values?

1190


What are the different types of subquery?

1235


How can we solve concurrency problems?

1122