mtassin (8/12/2009)

---

Lynn Pettis (8/11/2009)

---

Not all posts are related to the article itself. That is one of the benefits of this community and where you actually learn new things or...

mtassin (8/12/2009)

---

Lynn Pettis (8/11/2009)

---

Not all posts are related to the article itself. That is one of the benefits of this community and where you actually learn new things or...

How does that matter to solve the problem? you can have any name for your...

I think the sql server services is not running.

Can you check if it is running or not?

Please understand that this forum has people who are extreme experts...

Well .. I got the solution for this problem.

I had to install the Service pack-2 for SQL2K5 on the target machine for the restore of the OLAP DB as the...

Thanks a lot for the detailed explanation.

Steve,

Thats a important aspect that you have pointed out. I am now thinking in terms of separating the 'core data' and the storing of the images. There would be a...

Well, the solution of having a one to many relationship looks good and you have yourself suggested it.

What else info do you need on this?

Just try the below Sql. Just giving a shot that it 'may' work

 

SELECT Permnum,stulink,schoolnum,FirstName,Lastname,Grade,Gender,Concschool,Concishome,Case WHEN (concschool = '')and (concishome = 'X') then 'FLAG'

WHEN (schoolnum = concschool)and (concishome = 'X') then 'FLAG'

WHEN (schoolnum =...

As you have said that you got a VB6 dll working fine with SQL2K, you can create a similar VB6 dll and call the managed code written in C#. Then...

I always thought that a primary key constraint would sort the underlying column data.

But here I am surprised thats not getting sorted??? Why is it so??

http://www.windowsitpro.com/SQLServer/Article/ArticleID/9734/9734.html

Download the zip in this article.

If you are using SQL-Server-2000, then there are these 'Instead Of' triggers. 'Instead Of ' Triggers fire instead of the operation that fires the trigger.

 

An update opertaion would fire this...

I would take these files and doctor them to make them suitable for my needs in a language like VB (by inserting NULL or empty strings etc.) to make it...