Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behaviour
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Strange behaviour
Miscellaneous
Thread ID:
00870368
Message ID:
00870368
Views:
46
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.
Next
Reply
Map
View

Click here to load this message in the networking platform