Viewing 15 posts - 121 through 135 (of 153 total)
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/
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 7:01 am
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...
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:45 am
R u going to reinstall it?
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:35 am
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.
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:13 am
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...
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 6:05 am
hey, i hv to rush for meeting, so cannt explain much... but hope below links will help u...
http://qa.sqlservercentral.com/Forums/Topic351362-92-1.aspx#bm609225
http://www.15seconds.com/Issue/041006.htm
also, u can search on google for good example...
"Don't limit your challenges, challenge your limits"
April 9, 2009 at 5:02 am
@smith
+05:30 means 5 hours 30 minutes, not 5.30 hours
Yeah i know that 5.30 in timezone shows 5hr 30mins... but sql took it .30 after 5, that came into my conscious...
"Don't limit your challenges, challenge your limits"
April 8, 2009 at 11:07 pm
For IST (UTC+05:30), you should use an hour correction of 5.50 (decimal) not 5.30.
DATEADD(SECOND, (5.50 * 3600), GetUTCDate())
DATEADD(MINUTE, 60 * 5.50, GetUTCdate())
yeah!! i also notice this thing....
But I am confused,...
"Don't limit your challenges, challenge your limits"
April 8, 2009 at 5:53 am
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...
"Don't limit your challenges, challenge your limits"
April 8, 2009 at 5:20 am
Hey thanks! it is useful....
"Don't limit your challenges, challenge your limits"
April 8, 2009 at 4:26 am
Try this,
select sum(Convert(bigint,datalength(memTest),0))
from tblTest
"Don't limit your challenges, challenge your limits"
April 8, 2009 at 2:26 am
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...
"Don't limit your challenges, challenge your limits"
April 6, 2009 at 10:44 pm
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?
"Don't limit your challenges, challenge your limits"
April 6, 2009 at 10:26 pm
Please be more specific.
"Don't limit your challenges, challenge your limits"
April 6, 2009 at 1:30 pm
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...
"Don't limit your challenges, challenge your limits"
April 6, 2009 at 4:17 am
Viewing 15 posts - 121 through 135 (of 153 total)