Viewing 14 posts - 91 through 104 (of 104 total)
If you want to allow a column to have dupes, then don't set that column as PK.
Right, if there is no PK, by default, it allows dupes.
To avoid the case...
December 1, 2004 at 2:31 pm
I thought what I've done had fixed the problem but it came back yesterday afternoon. I ran the same script to fix it but it didn't work.
Let me repeat the...
November 19, 2004 at 8:41 am
November 18, 2004 at 9:55 am
Do you still have Error 17883 and database marked suspect ?
November 18, 2004 at 9:29 am
If you are going to backup more than once and you don't want to overwrite the existing backup file, you can use the following script which adds date and time to...
November 17, 2004 at 2:14 pm
Finally I got this problem fixed. The problem is the clustered index of Sysjobsteps table where step id is not in the order it suppose to be. Running DBCC DBREINDEX does...
November 17, 2004 at 1:55 pm
Steve, thanks for replying. No. It's not the history window. If you start a job manually it will pop up a window which shows all the steps, and you have...
November 16, 2004 at 9:57 am
I have not seen this before. But at this point you can try the following:
(1) try to create a job and see if it works.
(2) look for any errors...
November 16, 2004 at 9:06 am
Thank you all for the help.
Grasshoper - Your solution using FILEPROPERTY function is the best ! Please allow me to futher simplify as followed:
SELECT FILEPROPERTY(DbFileLogicalName, 'Spaceused') * 8.0 / 1024.0
Thank you so much,
Jimmy
October 27, 2004 at 2:16 pm
I just found out an undocumented command that provides the info I need:
DBCC ShowFileStats
and space used = UsedExtents * 64.0 / 1024.0
October 26, 2004 at 3:07 pm
Grasshoper - Thanks for the reply. I think you misunderstood what I want. Sp_Spaceused does not provide space used for a given .MDF or .LDF file.
October 26, 2004 at 2:05 pm
I tested. But sp_helpfile only provides allocated space.
October 26, 2004 at 1:54 pm
Thanks for your reply.
I didn't use any option in the DBCC CHECKTABLE. It ran for 24 hr that I've to kill it. Then I ran dbcc checkdb ('databasename', NOINDEX) with...
October 20, 2004 at 12:13 pm
Viewing 14 posts - 91 through 104 (of 104 total)