Good idea, I'll look further into that. 🙂

Do you know; if I create a SSIS package to handle backup of a remote server, will the backup data flow: 1) from...

Well apprently it was a firewall issue, even though all the relevalt ports was opened in all the profiles, the connetion issue stopped when I turned off the windows firewall.

/Rasmus

I was under the impression that Outlook generally communicated with Exchange and not SQL?

/Rasmus

Thank you...

rvje (7/21/2009)

---

GilaMonster (7/21/2009)

---

You can kill the shrink, it's not harmful to do so and it'll kill fairly quickly. However we need to find what's running that shrink and remove it.

Do...

GilaMonster (7/21/2009)

---

You can kill the shrink, it's not harmful to do so and it'll kill fairly quickly. However we need to find what's running that shrink and remove it.

Do you...

GilaMonster (7/21/2009)

---

rvje (7/21/2009)

---

None of them seems to be disabled. I found another thing that strikes me as odd though. In the treeview (the left pane) in management studio, I see...

rvje (7/21/2009)

---

MADHAN_PERS (7/20/2009)

---

Hi

I understand the requirement is to avoid fragmentation , but lets takeit step by step.

Error

====

Failed: (-1073548784) Executing the query "ALTER INDEX [IX_asstaging_1] ON [dbo].[asstaging] REORGANIZE WITH...

MADHAN_PERS (7/20/2009)

---

Hi

I understand the requirement is to avoid fragmentation , but lets takeit step by step.

Error

====

Failed: (-1073548784) Executing the query "ALTER INDEX [IX_asstaging_1] ON [dbo].[asstaging] REORGANIZE WITH (...

GilaMonster (7/20/2009)

---

Due to the way pages are allocated for small indexes/tables, very small indexes don't defrag properly. It's not a concern. Fragmentation only...

Sorry but I don't have and best practice expertice, I just wanna follow this post. 🙂

Cheers,

Rasmus

MADHAN_PERS (7/20/2009)

---

Hi

I understand the requirement is to avoid fragmentation , but lets takeit step by step.

Error

====

Failed: (-1073548784) Executing the query "ALTER INDEX [IX_asstaging_1] ON [dbo].[asstaging] REORGANIZE WITH (...

GilaMonster (7/20/2009)

---

rvje (7/20/2009)

---

The query runs successfully, but a check on the properties page of the index shows that nothing happend, they are still fragmented. I tried using the GUI for...