Recent content by oakgrove

Well thanks for trying to help. I gave up and uninstalled and the reinstalled so I can start work again. For what it's worth here is the contents of the oldest log but I think it is after I reinstalled 2006-07-21 10:01:50.47 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6...

-d and -e replaced Error logs? Event Viewer/System shows 1. Sqlexpress was sucessfully sent a start control 2. sqlexpress service entered the stopped state 3. sqlexpress service terminated with service-specif error 17058 4. The MSSQLSERVER service failed to start due to the following error: The...

Read William Gibsons newest novel <g> Oakgrove Computer Grouper Lansing, MI

If I understand you try to connect from an asp page to an sqlserver where the web server and the sqlserver are not on the same machine and it give you: "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." If you put the sqlserver on the same box as the web...

I would think the previous post would work. If not 1. Can you use distinct for just one column e.g. select (distinct ori), ...etc. ... from ... 2. If not I think you could use Group by Oakgrove Computer Grouper Lansing, MI

Hi, I have sqlserver 2000 running on winxp sp2. I recently had the HD changed to a larger drive all programs and files seemed to have transfered over ok. I just installed VStudio 2005 which put a copy of sqlexpress on the machine. Now when I try to start sqlserver2000 with the name of the...

Of course it is sql2000 that I am working with. In the services list I do not find MSSQLSERVER$instancename but what I do find is just MSSQLSERVER I did right click and reset "log on as" to "localSystem Account' This worked and I can now connect using EM using the instance name. Thank you...

I have a named instance of sql2003 running on XP and I used EM to change the Startup Service account from "System account" to the login and password that I use to start up the XP. The prompt said that window text search may not be available if I proceed. I said ok and then sqlserver stoped and...

I wonder if using SQLServer Client Network Utility might let you do something like you want. Just a wild stab in the dark. Oakgrove Computer Grouper Lansing, MI

I have a named instance of sql2003 running on XP and I used EM to change the Startup Service account from "System account" to the login and password that I use to start up the XP. The prompt said that window text search may not be available if I proceed. I said ok and then sqlserver stoped and...

Yepers! Oakgrove Computer Grouper Lansing, MI

I subclassed the VFP 9.0 ffc htmllistener class to modify the getpagelength and getpagewidth so it can be used on a box with no printers defined. The new vcx is noprinthtmllistener. I call it in a COM server “exe” to use it to print a report outputted as an html stream. This exe is called from...

Ok Now I got it. Thanks Oakgrove Computer Grouper Lansing, MI

humm, I must be missing your point select callid,localuserid from [sourcetable] where callid not in(select phoneleadid from [67.xx.xxx.xxx].[server1].[dbo].[targettable] where phoneleadid is not null) returns ALL the records in the source table not just the ones that...

good thought however sourcetable.callid is never null Oakgrove Computer Grouper Lansing, MI