charipg (10/27/2009)

---

ONE JOB FAILED BECAUSE OF BELOW ERROR.

DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Timeout has expired. ...

Jeff Moden (10/26/2009)

---

Silverfox (10/26/2009)

---

Hungarian notation has its place, Jeff, but it was more widely used for variable naming rather than table or column definition. I used Hungarian notation for over...

use year as the datepart argument when using datediff and your example will work. once you have modified it, based on the link supplied by Steve.

Nice article, good valid points and the links are interesting, still dont agree with virtualisation as the preferred solution for consolidation. I dont necesary agree with some of the points...

Ranga_CDS (10/26/2009)

---

Hi ,

When try to access or create a file in shared UNC path with full rights, I m getting access denied message.

I supposed to give a command in Query...

You should try working with sage then, the tables and colums are just a jumble of the alphabet, the main reason sage consultants get paid so much 😀

Hungarian notation has...

Without more information, the only option would...

You need to update the page then, it didnt say it was available 😉

Just read all the remaining articles 😀

I can always rely on you Gail to simplify everything down to idiot level 😛

When's the next article on aggregates, coming out... dont keep us waiting too long 😉

Good Articles,...

No worries Ian, It is nice to look at BOL and suddenly realise that you dont know it all 😛

Your ever humble servant lol

Nice Link Ian, much appreciated. good reference to refresh my memory 😀

harry-453265 (10/23/2009)

---

hi......

i hav a table in sql database.i want to keep track of table when i perform any operation on table like update insert n delete.how can i resolve this...

Have a look at the "managing transaction logs" link at the bottom of this post. it should answer any questions that you have.

I would suggest that your look at the links that Ian has given to you, You need a better understanding of what you are trying to achieve, before you ask...

S Hodkinson (10/23/2009)

---

I am going to say Yes and No. Yes because you need experience of other areas but No because I think you need to have experience of...