Flat file databases are :-

------------------------

Microsoft Works

Microsoft Access

AppleWorks (a.k.a) ClarisWorks

Borland Paradox

I'm not sure about the restoration of MS-ACCESS database using the 3rd party tools. If the database is crashed the...

You make use of the sql_dump stored procedure using the following syntax. Type it in your Query Window after connecting to the 'master' database.

exec sql_dump '-d (databasename) [-t (tablename)] [-f...

vijay, plz find examples of how to call SP through command object.

SqlConnection conn = new SqlConnection();conn.ConnectionString = "server=(local);Integrated Security=SSPI;" ...

Do they provide H1B sponsorship?

Functions

----------

1) can be used with Select statement

2) Not returning output parameter but returns Table variables

3) You can join UDF

4) Cannot be used to change server configuration

5) Cannot be used...

Andreas, You are a Genius !!!!!!!!!

Please find this examples.

The following example shows the default value of n is 1 for the char and varchar data types when they are used in variable declaration.

DECLARE @myVariable AS...

Brandie,

You can change the Time zone setting of your login in the following way :-

------------------------------------------------------------------------

1) http://www.sqlservercentral.com/Forums/EditForumSettings.aspx

2) Choose Date & Time Options

3) Choose Time Zone: from drop down...

Brandie,

I just gave suggestion / links to have a picture of understanding of how the questions will be and the areas where from the questions are asked so that the...

SQL Server 2005 Integration Services (SSIS) provides management, run-time, and design-time support for Data Transformation Services (DTS) packages that were created by using the SQL Server 2000 tools and object...

Hey,

There are many books available online & lots of sites offer you on practice tests/sample questions stuff...

I'll provide you some of those here..

Preparation Guide Links:-

------------------------

http://www.microsoft.com/learning/exams/70-445.mspx

http://www.amazon.com/MCTS-Self-Paced-Training-Exam-70-445/dp/0735623414

i agree with Phillip Cox

try out these links...Thought this might be useful to you.....

http://www.15seconds.com/issue/050106.htm

searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1197403,00.html

http://www.thescripts.com/forum/thread711362.html

http://www.ftponline.com/vsm/2002_11/magazine/columns/databasedesign/

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_22683964.html

http://www.codeproject.com/useritems/Debug_SQL_Procedure.asp

I'm not sure about 2000 but in 2005, since with the windows authentication itself, we can restrict the users to the maximum possible extent by not allowing them to roam...

SELECT P1.*, (P1.CA + P1.CB + P1.CC) AS SUMTotal

FROM (SELECT COLUMN1,

SUM(CASE P.COLUMN1 WHEN 10 THEN P.COLUMN2 ELSE...