I hv not done it in SS2k. though, hope below links will b useful to you...

http://msdn.microsoft.com/en-us/library/aa198334(SQL.80).aspx

johnjacobm.wordpress.com/2007/04/13/data-partitioning-in-sql-server-2000/

Do you mean you want to partition your database in SS2K?

partitioning is possible from SS2K5. If you want to hv such feature in 2k then you hv to change ur...

R u going to reinstall it?

i think, you hv to check users' rights (if ur server is on remote machine) for each n every authenticated users for different sql server services.

Hi,

I am agree with above post. I have Win XP on my laptop and have installed both SS2k5 and SS2k8; and both are working fine.

It will be helpful if...

hey, i hv to rush for meeting, so cannt explain much... but hope below links will help u...

http://www.sqlservercentral.com/Forums/Topic351362-92-1.aspx#bm609225

http://www.15seconds.com/Issue/041006.htm

also, u can search on google for good example...

@smith

Yeah i know that 5.30 in timezone shows 5hr 30mins... but sql took it .30 after 5, that came into...

yeah!! i also notice this thing....

But I am confused,...

Hey Flo/Paul,

thanks guys for helping me.

The problem in my code was, i was converting date with approx value in floating point terms. At last, we all come to one...

Hey thanks! it is useful....

Try this,

select sum(Convert(bigint,datalength(memTest),0))

from tblTest

Let me be clear...

The example code as above is for single xml file A_File1.xml, and you have 10000+ files such like, right? And you want to insert all files with...

yeah!!!

then, i think, to fight all the time with text type xml can b replaced with one time struggle in converting text to xml............

what u say?

Please be more specific.

Hi,

I have quick look over all the msgs in the post. My confusion is, why dont use XML datatype for the column instead of 'text'?, as the database is already...