Hi Ben

quote:

---

Although, I have managed to achieve what I want by creating a new column in the table and setting the default...

I hate to say this again, but I can't believe that since 3:00 AM (my time) I haven't received any mail, even not my own one.

Am I again the only...

Hi sqlinsite,

quote:

---

Please help! I am going crazy trying to explain testing and validation to my CEO. He scares the living...

Hi Tom,

quote:

---

This should do for you.

Microsoft Knowledge Base Article - 106122

sp_fixindex.

---

can you provide the full...

Well, I've been to this site, just out of curiosity.

Do you think it's intentional, that one can see the XML code, when one clicks on certain links

Hi wmp789,

quote:

---

Sorry, I found the thread about the same issue I posted before. See, the problem does cause duplicate postings...

---

Hi John,

for the Body of an email is nothing more than a text, why can't you simply collect the information about failed jobs, loop through them, concatenate into a say...

Hi blinton25,

quote:

---

SELECT Book1.COUNTRY, DatePart('yyyy',[ARRIVAL_DATE],1,0), Book1.ED_CARD

FROM Book1

ORDER BY 2 ASC, 1 ASC

which produces the following output:

Country 2002 2003

AUSTRALIA ...

Hi Wingman,

quote:

---

If I allow a user to use the SQL enterprise manager in his workstation but only want him to execute a...

Hi HenryTr,

quote:

---

Also you sure you want to do this word files that could be edited and cause all sorts of headaches (legal)...

Hi citrustrip,

quote:

---

I'm developing an access database with an sql server backend. The sql connection is set up for sql logins , but...

Hi Chris,

quote:

---

Thanks for that. Just trying to sound out how other people are doing this. It looks like we have a similar...

Hi ojanent,

quote:

---

Is there any other way than freeing more disk space?

---

shrinking tlog

skrinking db

not using EM

doing...