Viewing 15 posts - 33,736 through 33,750 (of 49,552 total)
Check the settings of 'allow updates' (sp_configure), check the SQL error log to see if that setting was changed recently.
Don't suppose you know when this started or that you have...
March 2, 2010 at 8:52 am
Has someone been messing around with "Allow Updates" and direct updates to the system tables?
Check the objects listed in those errors. Are they tables, stored procs, views, functions?
March 2, 2010 at 7:39 am
Ok, firstly, this is not a SQL 2005 server, despite the question being in the SQL 2005 forums.
Can you also run DBCC CheckCatalog?
Wouldn't be required on SQL 2005, hence...
March 2, 2010 at 4:07 am
john.mansfield (3/2/2010)
Thanks Gail. Does that mean to access the available memory we'll have to make the AWE tweak and be running the SQL Server Enterprise edition? i.e. Standard won't work.
No...
March 2, 2010 at 4:05 am
Please post the full output of the following:
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
March 2, 2010 at 3:39 am
If you use AWE, yes, providing the edition that you have can use more memory than that. Standard (and lower) are limited in what they can use
Why does the app...
March 2, 2010 at 3:38 am
Why don't you test it out and let us know if there's a measurable performance impact?
March 2, 2010 at 3:34 am
Rather get the 120 (180?) day trial version of Enterprise edition. There's a lot that's not in express. Or you can buy a developer licence (developer edition) for around $50.
March 2, 2010 at 2:33 am
No.
March 2, 2010 at 1:11 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
March 2, 2010 at 1:07 am
Raghavendra Mudugal (3/1/2010)
After gaining some experience in the SQL (basically on MSSQL2000), now planning to get my first certification done on SQL 2005 (Database Developer) (70-441 and 442)
The first exam...
March 2, 2010 at 1:05 am
Probably. I prefer it, as I can select columns, filter, etc without a temp table.
March 2, 2010 at 12:59 am
D.Oc (3/1/2010)
GilaMonster (3/1/2010)
No one interested in the soccer world cup?Yes, we are very interested in football (soccer) WC
![]()
So, which games are you going to...
March 1, 2010 at 1:10 pm
Viewing 15 posts - 33,736 through 33,750 (of 49,552 total)