Hi Preethi, I was able to finally install it. LOL. My db backend is 2008 Express. I'm sure that what we have in my previous work isn't the Express...
Hi Satya, If you recall, I think I posted on our 2005 dba forum. I remember mentioning losing my job. Well, I still have no job right now. :( Also,...
The one I installed today was version 2005. I'm installing 2008 version later. Thanks.
The first link I tried this morning, it installed version 2005. I'll try the new link on your last post. I'll let you know later. Oh, another...
<p> I'm getting an error connecting to my SQL 2008 server. What is the fix for this?</p><p> <img...
Thank you so much!!! :) I'm going to try them now.
Good morning folks, I just finished installing SQL Server 2008 Express. What is the equivalent of Query Analyzer, Enterprise Manager and Profiler for...
maybe, he really said cascade delete. Is this possible in 2000 or 2005?
Good afternoon folks, I chatted with a friend last night. He's also good in sql but not sure which one. He is also the person who does the...
That is awesome!!! As always, you have helped me so much! :) Thank you so much again!!!
Hi folks, I need some guidance. I lost my job. I would like to study clustering. I would like to know if someone can share to me a link on how to...
That is awesome!!! [:D] Thank you so much!
I would like to learn how to transfer a database from machine A to machine B on MSSQL 2000. I remember seeing files for the databases. I think the...
oh, this was from my old code. I don't have any "set lkey = @lkey" when count = 2, 3, 4 and 5. That's the only difference. :)
Disregard folks, I was able to write a solution. Glad that data isn't that huge. It worked like a charm. :) Here is what I did: WHILE @@FETCH_STATUS...
I'm actually exporting it to a text file needed by the other department. Here is a different data. I found out that they only need 3 tax id and I can...
Got it. Let's do it this way. Let's forget custloans and citem table. Let's use multitaxid table only. How will I return all the info records for...
Here is much more cleaner post. [:D] Sorry. create table custloans (lkey varchar(32) identity, loanno varchar(10)...
I think I'm wrong with table 3. I just looked at the table and it has 1 to many relationship. hhkey info abc 11-22-33 abc...
UPDATE: This post is incorrect. Please use my third post as my starting post. I can't delete this post, I'm not sure why. I would like to include...
Separate names with a comma.