Did you install the communications options with the odbc drivers when you installed SSE? If you do not do a detailed install they might not have been installed as...

I very much enjoyed the article and think it will be very useful in my developement work.  To switch to using catalog views in SQL Server 2005 isn't difficult at all.

For...

Yes... that is what Microsoft reports:  4GB data.

Here's an excerpt from the MSDN site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

The SQL engine supports 1 CPU, 1 GB RAM, and a 4 GB database size. ......

4 GB for Express actually.

Thanks to all who answered my question here!

Much appreciated.

I like # 3 and # 6... perhaps because I'm partial to yellow.  I like the size of # 1 though.

I also think the ray tracing (or whatever it is)...

We are experiencing a similar problem. At first Microsoft blamed Wise for not working with their merge modules properly and then Wise blamed Microsoft for bad programming. Neither...

But would this bypass the foreign key constraints?

Edited by - tgrignon@compusense.com on 12/23/2002 1:38:50 PM

I enjoyed your article very much. Can you tell me the name of the book you mention which is "out for those researchers in the biological sciences who want...

And then there's the low end of the market.

If MS is starting to take on the big boys in the RDBMS world, I think it's safe to say they already...

I enjoyed the article and agree with the idea of keeping things clean! Under the hostname field of the sysprocesses table I sometimes see my instance (compname/instance) and other...

I'm struggling with trying to create a UDF out of Brian's solution. Is it possible to pass a recordset to an UDF and return the median? I was...

That would do the trick!!! Thanks again.

Thanks Brian! That approach seems to work and is considerably more elegant than my approach. There is one assumption that seems to be important with it, though, and...

Steve,

Expanding your method I have a solution which, I think, will work (even if it is rather clunky!):

create table MyTable

( MyID int

)

go

insert MyTable select 1

insert...