Viewing 15 posts - 2,986 through 3,000 (of 3,061 total)
Mazharuddin Ehsan (8/27/2008)This deficiency is removed in SQL Server 2008 which can store date ranging from 1st January 0001 to 31st December 9999.
Boomer!... how about my 154BC records comming from...
August 28, 2008 at 3:21 am
Michael Meierruth (8/28/2008)
I know SYS and SYSTEM are like sa.Your crytpic response is creating suspense that's awesome.
Can you be just a bit more detailed in your explanations?
Cryptic? :w00t:
In regards...
August 28, 2008 at 1:41 am
Mazharuddin Ehsan (8/27/2008)[
2. As a developer I find EXP and IMP a very handy 'backup'
tool as it allows to take backup of selected objects in the...
August 28, 2008 at 1:36 am
Michael Meierruth (8/27/2008)
1- This doesn't work; you are importing nothing in your example.
Either you did not or you are a liar.
2- You do not want to exp/imp using SYSTEM account,...
August 28, 2008 at 12:35 am
Michael Meierruth (8/26/2008)
EXP SYSTEM/SYSTEM@ORCL FILE=c:\wherever\my.dmp LOG=%temp%\exp.log GRANTS=N OWNER=THEOWNERIMP SYSTEM/SYSTEM@ORCL FILE=C:\wherever\my.dmp LOG=%temp%\imp.log ANALYZE=N IGNORE=Y GRANTS=N FROMUSER=THEUSER1 TOUSER=THEUSER2
1- This doesn't work; you are importing nothing in your example.
2- You do not want...
August 27, 2008 at 8:37 am
Could you please define "5lakh"?
August 27, 2008 at 4:34 am
What do you mean by "connect"?
August 27, 2008 at 4:32 am
Glad it worked the way you where looking for 😉
August 25, 2008 at 8:41 am
You may want to research table partitioning.
Table partitioning allows for the fastest and cleanest way to achive data archiving and purging.
August 24, 2008 at 11:58 am
babloo.sqlnut (8/22/2008)
what is a page file?
Since there is not such a thing as a "page file" I would assume you are referring to pagefile.sys file which is a memory swap...
August 24, 2008 at 11:56 am
I want to know that is it possible to create a function by using
insert,update,delete command?
No.
August 24, 2008 at 11:50 am
1- Take a full backup of your database
2- Script database creation
3- Drop database
4- Alter database creation script to point to APP_DATA or whatever place you like
5- Run database creation script
6-...
August 24, 2008 at 11:44 am
how about adding an ORDER BY clause to your query?
August 24, 2008 at 11:40 am
I once experienced a serious bug in version 7.1.6
Do you still remember something that happened on version 7.1.6? :w00t:
Man, you have the memory of an elephant!... was it around 1995?
Oracle...
August 24, 2008 at 11:37 am
Viewing 15 posts - 2,986 through 3,000 (of 3,061 total)