I've looked, but can't find the procedure I developed. It's not too difficult, just copy the sp_who2 code to query analyzer, and make the changes to display the data you...

Budgets are seen as a hard commitment by IT to control costs. If a break in project requried by statutory changes is necessary, tehn something else has to drop off...

It's probably a good idea to prohibit downloading mp3's and similar files to protect teh corporation from excessive banwidth usage, and the potential for lawsuits related to illegal downloading activities....

It might be easier to take the code from sp_who2 and change it to generate the desired data directly. I did a modified version a couple of years ago to...

Use the information_schema.tables view to help you write a script that does what you need. I do this regularly with selects similar to select 'first part of text ' +...

Try running the SP via a pass through query. We do that in Access 97 on a regular basis. You can also use pass through queries to execute queries that...

If the backups are small enough, and the sizes you mention are, buy 32GB flash drives or SD cards, and copy the data to them. Have someone mail the backups...

Unless there is some compelling need to be able to retrieve the actual password, just encrypt it when you store it, then the next time the password is entered, encrypt...

jeff ernest (1/26/2009)

---

I work in a development organization, and I know there are sometimes where there are problems that are easier to fix with a re-boot, but there are other...

GSquared (1/26/2009)

---

I'd have to hear both sides of the story to be sure, but it sure sounds like a good way to go out of business in short order. ...

blandry (1/26/2009)

---

...and how exactly, does a company know the number of reboots? Do they have someone patrolling the cubicles to see who is rebooting? Does the worker then...

The linked article didn't have all of the information I've seen elsewhere. The docking of pay for starting and rebooting computers mostly applies to call center type jobs, where there...

Take a look at commercial time tracking packages. Some of them are pretty cheap on a per seat basis. Law firms, accountants, and other professionals use them to generate reports...

I will add that I think it is good practice for DBA ID's on production servers to be different than their everydya LAN ID's. This means they have to use...

If you use a decent one way encryption routine, you never need to decrypt the passwords. Just use the same encryption routine when the user enters their password, and if...