try with wizard.

the column might be referred in some FK.

i just tried to replicate this but i am not able to see any problem.

What I did :-

1) table create as order with startdate and enddate as 2 columns(both datetime)

2)...

really simple and best.

thanks for sharing. updated my sql library

seems like i didnt provide the correct information.

yes you can,

go in configuration manager-- go to client configuration--select alias.

you will have 4 option

alias name :- put what you want your server to be named as

pipe name/port number...

have you tried the one which i mentioned?

remove the extra exec here

so your @command_01 will be '['+@ServerName+'].master.dbo.xp_fixeddrives'

if you interested in using impor export wizard, then you can choose flat file as your destination to export the data in txt file.

the problem is because of this

set @command_01 = 'EXEC ['+@ServerName+'].master.dbo.xp_fixeddrives'

remove the extra exec...

the DMVs mentioned in the link are for 2005 onwards... but similar problem you can google with sql server 2000.

I am sure you will find some queries in this website...

sorry didnt noticed that

try

EXEC master..xp_cmdshell...

if you mean by 'export only data FROM all user tables' then yes select...

put this also in [dev\server1]

i think to be ready for interview, you need to first understand the requirement the company have which they generally mention in roles and responsibility.

They might be looking for...

just right click on database and select task option, you will be welcomed with import/export option

need to fix this bug..

http://www.sqlservercentral.com/Forums/Topic980983-391-2.aspx#bm981475