I'm going to download it on to my Mac tonight, light a candle for me.

Actually, I have two XP Pro sessions under Parallels,...

Don't forget to also copy over your MSDB database to get your jobs and DTS packages.

FYI, the link on the index page of the web site shows the end date of the raffle to be 8/24.

I think tape will be around for a good long time. As you’ve pointed out, it’s not easy to move 45TB of data from A to B unless it’s...

The problem with OSQL -L is that it doesn't discover multiple instances on the same server. Still, it gives you a list of primary points to investigate. I...

We recently lost our ERP system, and in the most stupid fashion. It's running on two IBM eServers (one app, one SQL) plus a DS400 SAN unit for my...

My best hours were my first decent IT job. I worked 10am-7pm, so I missed rush hour in both directions and had two hours every day when no one...

I think that I've found the error in my case. It relates to having an index on a Float data type and not having a hot fix for SP3A...

I was hoping. But I was also anticipating that this might be your answer, what's 2 1/2 years between proverbial friends?

What did you find was the problem? I'm getting the same error and my DBCCs aren't finding any issues.

My table design is:

CREATE TABLE [Cont_Load].[f213] (

[fid] [int] NOT NULL ,

[numofpts]...

Yeah, I noticed the code was 2K5-only when I tried to run it in Query Analyzer and it didn't work. So I cheated. I created the UDT through...

And for us SQL Server 2000 folk:

create rule [uIntRule] as @value BETWEEN 0 AND 4294967295

GO

EXEC sp_addtype N'uInt', N'bigint', N'not null'

GO

EXEC sp_bindrule N'[dbo].[uIntRule]', N'[uInt]'

GO

I wanted to experiment, I've never created UDTs...

You have my sympathy, Loner. I work in city government, so I know we don't have executives with salaries like that! Unfortunately all too many companies are like...

And that's why we get paid the big bucks! (in a parallel universe very much like our own)

Huh. Learn something new every day.