Hi,

Here is the table schema..

Id -> int

title -> nvarchar (200)

body -> nvarchar (4000)

categoryID -> int

datePublished -> datetime

postedby -> varchar (20)

searchkeywords -> varchar (200)

blogsummary -> varchar (300)

The execution error I am...

yes, body field is nvarchar as it needs to accept unicode characters.

Thanks Gail! Works perfect!

Hi, Thanks for the response!

Blogs in the BlogEntry table can have comments in the BlogComments table.

But in the same time there could be rows in the BlogEntry table where there...

I love this site! Thank you and have a happy newyear!!

Thanks for the reply Will. My 2nd attempt was ok. I was able to install SS2000 in Vista and use it for ASP.NET development.

Hi,

I am trying to install SS2000 personal edition in Windows Vista SP1 but after hitting OK for every warning message it install the server but at the end it fail...

Hi Dugi, thanks for the quick reply. Here is the vb code that do this search. Isn't that same as yours?

Public Function Search_Related_Videos(ByVal search As String) As DataSet

...