I would DEFINITELY recommend having spares on-site. To argue on the grounds of budget is to be penny wise and pound foolish. It's like scrimping on your insurance,...

The error in the event log is

quote:

---

17204 :

FCB::Open failed: Could not open device F:\SQLServer2000\SQL_SystemLog\TempLog.ldf for virtual device number (VDN) 2...

I'm surprised that people are so against UDTs.

I tend to regard my database servers as flexible when they have to be, but I don't encourage changes to schemas...

I've come across this problem in SQL 6.5.

Pre-SQL2000 my solution was to have a test machine that I could set up SQL Server 6.5 with whatever character set...

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...