Great Question.....

However, I executed the below two queries, but, getting the below error...

:out C:\testoutput.txt

SELECT @@VERSION As 'Server Version'

!!DIR

!!:GO

SELECT @@SERVERNAME AS 'Server Name'

GO

Error Msg:

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

Msg 102, Level 15, State 1, Line 1

Incorrect...

Good Question.

Yes, it is Wondows Server 2003, Service Pack 2

Thanks Alex... Looking like at this way, Synchronous would be good.

By the way, let me know if there is any good document available to implement Sync DB- Mirroring (with step...

I too need one T-shirt ! Lolzzzz

I guessed Option:1.

SSMS QA says: 1752-09-09 00:00:00.0000000

Not sure, why the correct answer is :: Option No: 3

Can anyone please recommend further?

Any suggestion please??

Thanks for the suggestion..!!

However, what would be the additional 'switch' to be used to create an OUTPUT file?

I too am facing the same error..

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

This is...

Dear Chandra Garu

Using LiteSpeed utility, we can take Splitted backup of Database. Let's think, I have a database of size 500 Gb and none of the drive has free space...

Dear Chandra Garu

Using LiteSpeed utility, we can take Splitted backup of Database. Let's think, I have a database of size 500 Gb and none of the drive has free space...

How about the SQL Server DBA Presales IT profession? Can we earn good exposure of knowledge and salary?

=====================================

create table #test2 (rowid int)

insert into #test2

select top 10 row_number () over (order by name), name

from master.sys.all_columns

======================================

The above code will fail because in the 'Table Definition' I have provided...

The question was little confusing !!