Recent content by anikanchan

Denis, Thanks for your response. I was trying to use the SQL Diagram but the problem is that it does not give the relationships between the tables. Is there any way I can show it on the diagram without manually doing it. I have around 90 tables here. Thanks again. Anikanchan

Hi good fellas, I am working with this huge SQL Server database that has no documentation. I was wondering if there is any way I can create the ER diagram from the tables in the database. Any answer/input/suggestion is highly appreciated. Thanks Anikanchan

Thanks for all the inputs guys. But, nothing seems to be working yet. I tried ContentType ="application/vnd.ms-powerpoint" also but invain. Vexing issue is that the same thing works in our dev environment. Can anyone think of any solution please?

Yes, it does open...

Not sure about it but that should not matter, should it as I am downloading the file to my local machine and it downloads also but it has 0 bytes. If I try to open it on my local machine, it opens but does not contain any thing.

This is the link I get... <a href="\erdb\open_file.asp?filename=38275.4750231481Triple%20Clamp%20Bushings.ppt&approved=1"> and it looks fine. Funny thing is same link works for other types of files. Only problem is powerpoint and it is killing me.

That works fine...I just tested that. Thanks

This is where link is being placed on the asp page....... <tr> <td> <table cellspacing="0" border="0" cellpadding="0" width="100%"> <tr> <td class="InputLabel" colspan="2"></td> </tr> <% If IsObject(oRsAttachments) Then do until...

Hey guys, I am having problems with Powerpoint links from my ASP page. The ppt files are saved on the server and link is dynamically placed on ASP pages depending on the search criteria. When I point my mouse to the link it gives correct filename (example: 38275[4].4728819444Tempest DIB VQ...

Thanks jbenson001, Here is the sample data: Company Dept # Dept Name 010 01110 Office of the President 010 03160 Executive Services 010 01240 Dir Internal Audit 010 01250 Corporate Audit & Advisory Svc 010 01260 Systems Audit 010 01270 Cust Audit Services 010 01280 Quality...

Hello guys, I need to update table where lenth of the characters is less than 5 for a column and I need to add a leading zero to it. Can someone help me out with this please? Actually, I am copying data into a table from Excel file and it leaves the leading zero. If I can copy it in such a way...