Viewing 15 posts - 39,286 through 39,300 (of 49,571 total)
There are no errors in that. The model database is starting up without any problems. If model were damaged, there would be lots of high severity errors in there.
Is your...
May 6, 2009 at 2:09 pm
barunpathak (5/6/2009)
1) Do I overwrite the same files everytime?
You can, but what if you need to restore an older backup, either because the newer one is corrupt (it happens)...
May 6, 2009 at 10:23 am
Security, security, security and just for completeness, security.
They need to understand and understand the reasons for the Principle of Least Privilege.
They need to understand injection and how to prevent it...
May 6, 2009 at 9:52 am
I have no idea how to uninstall MySQL and I have no idea what the error means. I haven't worked with MySQL in 5 years or more.
I suggest that you...
May 6, 2009 at 7:14 am
sumanta.roy52 (5/6/2009)
May 6, 2009 at 6:42 am
ajitkumarng (5/6/2009)
Try shrinking database
Bad idea. Lots of side effects and, besides, if the log is full it won't do anything other than fragment indexes.
May 6, 2009 at 6:38 am
SQL Server doesn't have versions 4.01 or 5.01. Are you sure it's Microsoft SQL Server that you're working with and not MySQL? Your comment about studying PHP and MySQL suggests...
May 6, 2009 at 6:27 am
ALZDBA (5/6/2009)
I've tested in on SQL2008 SP1. (10.0.2531.0 (Intel X86) )
It gets even worse if you explicitly use the ID column in the filtered index...
May 6, 2009 at 6:18 am
SQL-KV (5/6/2009)
But i received only this : (after running the command - which you have given.)Command(s) completed successfully.
That means there's no corruption, which is a good thing.
But i wish i...
May 6, 2009 at 6:17 am
If you have database mirroring, the recovery model cannot be changed from full. The only way you can achieve what you want is to completely drop the mirroring, switch the...
May 6, 2009 at 2:48 am
No worries Jeff. By digging up proof for you I learned some stuff about filtered indexes too. 😀
Sheng, I chatted with some friends about this. It appears (though I haven't...
May 6, 2009 at 2:11 am
Please run a full checkDB on that database. By leaving out the indexes you may be missing corruption, especially since the error says that it's possible index corruption.
DBCC CHECKDB (<...
May 6, 2009 at 2:04 am
Does the login you are using have rights on that DB?
May 6, 2009 at 2:03 am
juan_wiski (5/5/2009)
When you use several views that each one of then has several tables plus Cumulative queries. That's how!
Ouch. That's just asking for performance issues, from the compiling if nothing...
May 6, 2009 at 1:57 am
Steve Jones - Editor (5/5/2009)
Well here's a nice April Sat morning in Denver:http://lh3.ggpht.com/_8hTidvPiTuU/SgCqmUxlXLI/AAAAAAAAAiI/pxf8WYs9zH0/s512/Apr_snow_a.jpg
And here's lunchtime:
http://lh5.ggpht.com/_8hTidvPiTuU/SgCqmB_QA8I/AAAAAAAAAiA/VMCiDCZDEa0/apr_snow3.jpg
And here's late afternoon:
http://lh3.ggpht.com/_8hTidvPiTuU/SgCqlzeT1vI/AAAAAAAAAh4/XmnjzlFDV0w/apr_snow2.jpg
It was gone by Monday.
Cold, cold, cold.
May 5, 2009 at 3:27 pm
Viewing 15 posts - 39,286 through 39,300 (of 49,571 total)