Viewing 15 posts - 226 through 240 (of 1,291 total)
Have you made sure, who added that trace flag?
From the screen shot given by you, it is missing a semi colon ";" after the mastlog.ldf
It should be something like...
February 15, 2010 at 12:05 pm
Change your code like this
WHERE DATE >= DATEADD (YEAR, - 2, GETDATE())
February 15, 2010 at 8:43 am
nandini_makkena83 (2/15/2010)
hi,I want to join sql dba. which institute is the best. please suggest a good institute.
Do you mean joining a training institute? Where exactly are you located? With that...
February 15, 2010 at 7:20 am
Thanks Steve and Grant for your input.
I am going to register for the Summit 2010 and looking forward to meet you all there..
February 12, 2010 at 7:40 pm
GilaMonster (2/12/2010)
Google's english to afrikaans translator's not that great either apparently...Lalani kahle abantu bonke.
A e be boroko lena bohle.
Rhonantini.
Now I don't find Zulu translator, all I know about Zulu was...
February 12, 2010 at 2:19 pm
GilaMonster (2/12/2010)
CirquedeSQLeil (2/12/2010)
Ok - Thread commandeered. Should we go all french all the time?Jy kan, maar ek nie Frans praat nie. Miskien sal ek Arikaans of isiZulu praat.
Wel, ek...
February 12, 2010 at 1:27 pm
As mentioned by others, do you get an error when executing the stmt or it takes time ?
How many rows are you going to be deleted coz of that stmt...
February 12, 2010 at 1:00 pm
Roy Ernest (2/12/2010)
You all go french, I will go malayalam. (My language) ... 🙂Merry and Mary... Not much difference... 🙂
So Roy, you are from Kerala ?
February 12, 2010 at 12:57 pm
Well you can ask your DBA to filter it out only that Database and also in the Application Name filter it to something like " % DTS Designer %", so...
February 11, 2010 at 2:31 pm
How are you trying to script the Index, I did try and could script the included columns..
February 11, 2010 at 11:05 am
Gift Peddie (2/11/2010)
Bru Medishetty (2/11/2010)
I am not sure with this, but though it might helpful.I never came across a SQL Server Edition with SP1 installed (something like embedded).
There are many...
February 11, 2010 at 10:08 am
Have you read the error statement completely and what have you done in response to it ?
Your temp DB file settings need to re-looked either add additional file or change...
February 11, 2010 at 9:44 am
I am not sure with this, but though it might helpful.
I never came across a SQL Server Edition with SP1 installed (something like embedded).
February 11, 2010 at 9:39 am
As Greg mentioned, there is nothing like DTS in SQL 2005, it is replaced by SSIS.
You also mention that there are 100 jobs, are those 100 jobs all running SSIS...
February 11, 2010 at 9:37 am
Viewing 15 posts - 226 through 240 (of 1,291 total)