Hi Guys,
I am having a very strange problem. When I run a query in enterprise manager(server machine,open table, return all rows, click on sql button and type the query there) it runs super fast. When i run the same query in the query analyzer on the server machine it hangs. This also happens If i run this query from a VFp Client or .net. it just hangs. can someone help me.
The Sql server is running on Windows 2003, 1 gb mem, 300 gb hdd.
The LDF file is 110 GB
the MDF File is 17 GB. No backup of the transaction log has ever been run. The IT Manager only let me know this 1 day ago.
TIA.
Fred Besterwitch, MCP
The harder you work. The luckier you get.