Sorry about the spelling in the previous post. Some swine switched the office coffee for decaff.

Steve raises an interesting point.

quote:

---

People don't know what they want.

---

But they sure as...

I wonder how those of you who became managers, how you became so?

Were you formally trained or did you come into the office one morning and realise that most of...

If programmers ran the company? Read Animal Farm by George Orwell.

Also, how many of the DOT COM start-ups WERE run by programmers, and before that the Silicon Valley start-ups?...

The last database on earth that I want to default to is master!

If you are going to default to a system database then I would make it TempDB. At...

I had a friend who said he would sooner see a bad idea implemented well than a good idea implemented badly.

He was refering to Mercedes windscreen wipers at...

Versions of MDAC after 2.5 loose the ADSI and LDAP features

One of our developers complains that a lot of stuff got taken out of MDAC 2.6. Unfortunately he is on leave so I can't elaborate.

If you are running MS...

I think this also illustrates why it is important to keep scripts of your database objects.

OK you can go in and add then remove a space from your view/stored proc...

I've had the same problem. As far as I can see sp_recompile does absolutely nothing.

I've tried

• sp_recompile <<the changed table>>
• sp_recompile <<the dependent view>>
• sp_recompile <<the...

As a cynic I would say that tech support for SQL Server is

• Books on line
• SQL Server Central
• MSDN

in order of preference.

I showed an ORACLE developer...

Read Dale Carnegie's "How to win friends and influence people". It may be 70 years old but he said virtually all this back in the 1930's.

Interesting

I've always insisted that stored procedures were prefixed with usp (user stored procedure) so that I can spot the ones for which I should expect documentation.

As there are an ever...

..and of course simply bunging in another processor adds to your licensing costs, never mind the cost of RAM, disk and tapes.

Great Andy,

There is an issue here of "who owns the data".

Your particular example is something that can be decided by the IT department as it is their own internal logging...