thanks for that.

I can change that to varchar(512) or something, but I was wondering if there is a configuration setting or something in sql server which will not allow that to happen....

thanks for the replies Guys,

CREATE TABLE TEST (TEST2 VARCHAR(MAX) NOT NULL);

go

ALTER TABLE [TEST]

with check add constraint [ck_test2]

CHECK (len(ltrim(rtrim(isnull([test2],''))))) > 0 );

go

This is the check constraint am...

thanks for the replies,

I did not mean was inserting null,,, but if you see nothing in the column , is it not similar to inserting unknown value. I dont...

Thanks for tht information.

Nikhil

thanks,

Nikhil

Thanks a tonn dude,,

for all the help.. it worked....

Thanks for the reply,

I dont think I can install anything on this server, so that is the reason I used to take manual backups instead. I read stuff which says...

Thanks for the reply,

SQLCMD is not installed

thank you guys for all the replies.

After a lot of r & d, I thought there was no solution for my problem but to either change the path directly when...

Thanks a lot for the reply. so there is no way of doing this.... apart from using a script..... I could find registry entries for changing default locations for folders...

Thanks Gilamonster for the reply,

Yes,

The tables which had few tables created problem for me. Though, after realizing that, I did rebuilding on tables which had more than 100,000 rows, and...

thanks for that link,

it helped me a lot..

Thanks for all the replies...

Gila Monster

I could not answer as I came in a little late today. We are using MSMQ (microsoft message queuing) for batch processing.

P.S Davidb

David...

thanks a lot for the reply.

I was wondering if the software you specified was only for UNIX as I am using windows server 2003. Also, do you know any other...