backup file located at one server disk and backfile mdb located at other server disk..........

thats is not empty string just name purpose only i leaved it blank...

This Question is Based on Index Structures

Spatial and Filtered indexes have a B-Tree structure.

Full-text indexes have a token-based functional index.

XML Primary indexes have an internal table(aka nodes table)....

Good Question .....By Seriously I attempted the question luckly my answer is match with answer....

The CODEPOINT() is a rarely used function in the SSIS expression language, but can be an effective tool in your ETL arsenal in some cases.

Its Getting Error Or ?

Nicely Fooled Every One By This Question.............!

SQL Server 2008 provides Resource Governor, a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the...

In SQL Server 2005, column-level (sometimes called cell-level) encryption became available. Now, encryption could occur within the database, but it was not easy to use, offered poor performance, and it...

and then from all users try to post questions with wrong answers ..then who was responsible for this kind ...

The Responsibility is more on the Question Posted by the user....he has full responsible for all this.....

Normally there are 3 types while performing restoration,

1.Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH ----)

2.Leave...

YAA STARTED WITH NICE QUESTION AND LEARNED MORE SQL 2008..!

Nice Question ....Today i learned this from Central...Good Question

http://www.simple-talk.com/sql/ssis/ssis-package-componentization/

Good Question i thought that it would be Raw File Source But nope.........good and very typical one