Viewing 15 posts - 44,611 through 44,625 (of 49,571 total)
Depends on what the trigger's doing.
Triggers run in the context of the transaction that was started by the statement that fired the trigger. That transaction is only committed after the...
September 10, 2008 at 7:44 am
You'll have to buy one of the editions of SQL server. I don't know if you can still buy SQL 2000 though. Without knowing what you're doing, I can't say...
September 10, 2008 at 7:42 am
No. SQL does not support files on raw disk. NTFS file system is best.
September 10, 2008 at 7:32 am
Shaun, I don't know who that was intended for, but changing the web page as rendered is not required, cross site scripting is not required, adding anything to urls as...
September 10, 2008 at 7:22 am
You'll need to test carefully even if you do leave the DB in 80 compat mode. There are enough changes (to the optimiser especially) to potentially break things even running...
September 10, 2008 at 7:06 am
Shaun McGuile (9/10/2008)
Erm Ed, just one thing,removing read permissions on sys tables so the web app can't see them kills this type of attack stone dead.
It kills this particular instance...
September 10, 2008 at 7:06 am
That is MSDE, as shown by the last line 'Desktop Engine on Windows NT 5.1'
MSDE will slow down after 8 concurrent queries. It's an intentional throttling and there is no...
September 10, 2008 at 7:04 am
Online indexing won't work, neither will any of the new 2005 features. You will get the benefit of the improved query optimiser and other internal changes.
Why can't you change to...
September 10, 2008 at 2:50 am
Please post the full result. Change QA to run to text, not to grid.
September 10, 2008 at 2:33 am
At my previous company, we gave the devs dbo access to the DBs that they were working on (on the dev server), however there was a DDL trigger in place...
September 10, 2008 at 2:32 am
The PSS engineers have looked into this and posted the following on the subject:
September 10, 2008 at 2:17 am
The ITP exams for SQL 2008 won't be out til around November. I don't know if the upgrade exams will be out the same time, or later. I'd guess, offhand,...
September 10, 2008 at 2:15 am
It looks like you're running MSDE (the free SQL 2000 database engine). MSDE has a built-in throttle that limits it to a certain number of concurrent queries and you're exceeding...
September 10, 2008 at 2:06 am
Please don't cross post. It just wastes people's time and fragments replies.
Markus answered your question over here:
http://www.sqlservercentral.com/Forums/Topic566620-146-1.aspx
September 10, 2008 at 2:02 am
Viewing 15 posts - 44,611 through 44,625 (of 49,571 total)