Viewing 15 posts - 256 through 270 (of 860 total)
Do you see anything in Error logs just before this happened?
April 8, 2009 at 11:18 am
thanks Lynn I was being silly enough:-D
April 8, 2009 at 11:17 am
Mohit,
But I am thinking it will only overwrite the existing product version details and gets updated, are you sure even the system objects gets over written and even if they...
April 8, 2009 at 10:58 am
psangeetha (4/8/2009)
April 8, 2009 at 10:48 am
mldetch (4/8/2009)
April 8, 2009 at 9:30 am
Subhash (4/8/2009)
Question: what will be the impact due to this proc which has only begin tran with only select statements and NO DML and NO commit tran
and also will...
April 8, 2009 at 9:25 am
Hi,
What is your SQL server edition and also how many connections did you define? Is it an express?
April 8, 2009 at 9:22 am
Joseph (4/8/2009)
what i am thinking is installing sp will modify structure of system dbs...
No, I don't think it will
either we have security issues or not, we have to install...
April 8, 2009 at 9:17 am
brianc (4/8/2009)
My question is: How do I go about downsizing this .ldf file, and how can I keep it from doing this again?
Simple Recovery model
I have consulted with technical...
April 8, 2009 at 9:14 am
PaulB (4/8/2009)
That was fast Krishna 😀 100% agreed.
Thanks Paul that was kind of you 🙂
April 8, 2009 at 8:38 am
psangeetha (4/8/2009)
The table structure is as I said above, has 2 fields with 2 non-clustered indexes. The table has 1.5 million records and it...
April 8, 2009 at 8:38 am
psangeetha (4/8/2009)
Paul,While collecting statistics for all the indexes, I happen to find this problem that there is no clustered index on these 2 tables and hence its fragmented.
Sangeetha,
Tables gets...
April 8, 2009 at 8:15 am
ben.rosato (4/8/2009)
Results areCurrently allocated 11300.00 MB
Available free space 798.88 MB (7%)
So, its almost changing by 1GB?
April 8, 2009 at 7:49 am
oOOPS isn't it, the mdf file gets over written, I am acting such a dumbhooo
April 8, 2009 at 7:39 am
prabha (4/8/2009)
Hi Guys,"No possibility"
It is but using a third party tool. You can read the log file and its internals...
April 8, 2009 at 7:02 am
Viewing 15 posts - 256 through 270 (of 860 total)