Correct !! i think u can use logical name in ur case.
whts the current file name dbname_log.ldf or dbname_log ? actually .ldf extension is just for our understanding,OS /SQL server will not interpret...
insert data like 12/4/2000 12:30 AM But select gives "12/4/2000 12:30:00 AM" .We dont need that 00 (second's field) .What is the issue here.any idea...
Also one more question. Will Primary key index(clustered) will occupy space on disk?See the scenario >exec sp_spaceused...
In Short , Production is where Business runs Test/Developemnt is where we test or develop new features and test it with data from production.Once...
So do you think drop/recreate primary key will solve the issue?IS it recommended ? If so , i would recreate the primary key as non-clustered index...
What is the recovery model ? If it is running in FULL recovery model ,configure a log backup job to backup transactional log If log backup is alredy...
Thanks Thomas .But my record is more than 7 CRORE . Can any one say what gone wrong here.It is Table or Index currupted? Error message says about...
Thnaks Satya ! From the error above can you tell table or Index currupted? Table 'tblDC_AccumulatorQualities' has three columns with one primary...
Table 'tblDC_AccumulatorQualities' is causing trouble .Its a table with three columns and PRIMARY KEY on two of those columns. Is there any way to...
Hello Guys,after a short break I am back(Hmm with some issues in hand [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] )<br /><br />I got...
I know i am running SQL server standard edition (Microsoft SQL Server 2000 - 8.00.760 ) and want to go for sp4 . But confused seeing SP for SQL...
Oh yes it is OS service pack. Thanks buddies ,for the quick reply . Should i stop SQL Service/Agent service while installing SP . anything to be...
Hi, my select @@version gives ... Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft...
Hi is there any ways to find out when Windows BOX is restarted ? Other than checking SQL error log . Will it mark anywhere in event viewer ?
I dont have any experience in SQL6.5 . As in 7.00 and 2000, check if there is any option to generate script from Enterprise Manager . Something like...
What exactly that UPDATEUSAGE will do ? Will it help reuse space occupied by deleted records.Could you please brief it
Satya, here the issue is about datafile . "though i am deleting rows daily database size is increasing" . So there is more deletions on daily...
backup log <your DB name> to disk = <<img src='/community/emoticons/emotion-4.gif' alt=';p' />ath><br /><br />or<br /><br />backup log...
if your DB is FULL recovery model ,<br /><br /> *Do you have a log backup scheduled ?<br /> <br />for now you can issue follwing command<br /><br...
Separate names with a comma.
