Viewing 15 posts - 256 through 270 (of 790 total)
No, I have installed just the Oracle 8i for the Application but it doesn't cause the problem because it works till before some update so after these unremembered updates it...
August 27, 2009 at 6:43 am
Let say that the first Sunday of this year is 04/01/2009 ( date format is dd/mm/yyyy)
And the secondary you should have Tally Table ....you can find here http://www.sqlservercentral.com/articles/T-SQL/62867/
[/url]
After you create...
August 26, 2009 at 1:59 am
Yea nice question and nice explanation from your point!
I agree that no Junior or Senior DBAs, sure that I meet someone who has over 5 years and they don't know...
August 25, 2009 at 1:50 am
Jeffrey Williams (8/10/2009)
SQL Server Integration Services - schedule through Windows Task Scheduler or SQL Server Agent
SQL Server Agent Jobs
Windows Task Scheduler...
August 11, 2009 at 7:44 am
You should go for MCTS then you should continuewith MCITP.
No more need for MCDBA! All of them who has passed the MCDBA must be upgraded to MCITP (DBA and DBD)....
August 10, 2009 at 7:08 am
Nice Explanation here Andy!
In SQL Server 2005 we have GUI to configure DAC, so in SQL Server 2008 this GUI is gone, it must be configure with T-SQL!
August 6, 2009 at 5:40 am
vishalsheth9 (7/7/2009)
I think I accidently ran the delete/truncate script (using cursor) on the master DB and the problem started...
July 8, 2009 at 1:18 am
MarkusB (7/3/2009)
Dugi (7/3/2009)
You can do it with third party tools, like RedGate Log rescue, Apex SQL, etc etc ...you can find many of them in the Internet!
Just keep in...
July 3, 2009 at 3:36 am
You can do it with third party tools, like RedGate Log rescue, Apex SQL, etc etc ...you can find many of them in the Internet!
July 3, 2009 at 1:19 am
As Lynn Petis said, very simple:
DBCC CHECKIDENT (YOUR_TABLE_NAME, RESEED, 0)!
Or if you plan to delete all data in your table, you just Truncate the table and the Identity value will...
July 3, 2009 at 1:14 am
Ok! Now we have choice to separate date from time declaring them as independent data types, but must have some care during development level that the date to be or...
July 2, 2009 at 7:01 am
Viewing 15 posts - 256 through 270 (of 790 total)