Nothing beats experience. But how do you get it if you don't have it? Most likely by easing into it from the side. You will need some...

quote:

---

We need to express an integer (eg 1034) as words ("one thousand and thirty four").

Does anyone here know of anything that'll do...

cool. let me go vote ...

how about delegating it to a junior programmer as a learning experience?

microsoft.com runs on 16 linked servers, each quite large in size. I saw a pretty neat overview (not TOO much marketing hype) at the local MSDN event they have...

quote:

---

I'm curious as to how you automate the removal of the logins.

---

from BOL:

sp_droplogin

Removes a...

from BOL: Anyone can create a job, but a job can be edited only by its owner or members of the sysadmin role.

We use a separate ID to own...

If you don't need to store the package locally, you can save it as an external file, place it on a network drive and then use DTSRUN to execute it....

Depending on the traffic volume, you could try matching up the IP addresses from your web server with the time stamps of when rows are updated/inserted on your data base....

I know of several sites that use a product called Business Objects. I don't have any 1st-hand experience but it would be worth at least looking at.

This looks like an ad.

If you have some way to deal with the row causing the problem, you can set you job up to "quit on success" in that step and "go to the...

Do you have any NT Event log entries that report any hardware related problems around the same time?

Do you have your server set to create a dump on a hardware...

bat files always return 0 as their return code. There's a switch to use that causes the last command's return code to be passed back as the return code...

You might be thinking of the considerations for when you have >2Gb of memory on your machine. Check out BOL topics "Managing AWE Memory" and "Server Memory Options" for...