Viewing 15 posts - 1,741 through 1,755 (of 1,995 total)
the only way i can see to do this is to load the array into a temp table, cursor or table variable and then loop through table/cursor
August 5, 2005 at 9:56 am
i ahve seen this error and it seems to be specific to windows 2003
mdac 2.8 - installed by default on windows 2003
the following 2 articles may be of...
August 5, 2005 at 9:50 am
I can strongly recommend Ideras SQL diagnostic manager
at £450 per server it's a bargain. this should then give you a report on the slowest running Queries and procedures...
August 5, 2005 at 9:44 am
Microsoft don't state that there is a an upgrade path to std/enterprise edition from personal, however from past experience i can confirm that you can upgrde.
this should minimise your downtime....
August 5, 2005 at 9:41 am
has anyone come up witha fix for this yet ?
I'm getting a similar error - although this is only happening when not using connection pooling.
It appears that connections are not...
August 5, 2005 at 9:34 am
the response from idera was so slow that i posted it here first, but it appears that contra to their installation requirements and pre-requisits you must have SQL server...
August 4, 2005 at 2:15 am
funnily enough thats my script!!!!
i know you're all jumping to conclusions here...... but i post a lot of scripts!!! and this one has been no-where near that particular customer...
the issue...
July 22, 2005 at 3:05 am
fortunatley as part of all upgrade work we do for that customer we always script out the database design in case we need to make changes
so i've got a...
July 21, 2005 at 5:49 am
ERIC - that looks suspiciously like a TI/99-4a on your picture
July 15, 2005 at 7:36 am
the reason c generates that error si that the final prameter of the last sp_dboption dies not use ' - they may look like ', but it's not.
you'll see it...
July 15, 2005 at 6:17 am
i've found instances in EM where it looks as though the database is in simple, but it never truncates.
so I always use ALTER DATABASE SET RECOVERY SIMPLE/FULL
though my colleague here...
July 15, 2005 at 3:23 am
Typical -
when fault finding on a system you go for the most obvious errors before delving into minutiae
I think they should give us the points for finding the...
July 15, 2005 at 3:13 am
yeah - i just got bummed by it too!
July 15, 2005 at 2:14 am
185 Gb, but i can't be bothered to jam up my test server and also i don't think i have enough t-log space
July 12, 2005 at 6:37 am
Viewing 15 posts - 1,741 through 1,755 (of 1,995 total)