raful_k (3/11/2009)

---

ok, created on both servers but got the same error, tried with only public role and then with sysadmin, also tried to give grant connection to that login but...

Check to see server allows remote connection and protocols like TCP/IP are is enabled in the SQL Server Configuration Manager and Surface Area configuration.

Thanks.

2GB memory is not enough for most production SQL server enviornments. Those memory flush means you have memory contention issue on your server. When SQL Server starts it...

When you install SQL Server Clustering services and tell it the nodes that will be joined in partnership the installer will automatically install the required SQL Service Component on the...

That object exist in the master DB; however I am not sure the purpose for it. I can't find much information on these tables.

Thanks.

Yeap you can still post the query here as an attachment though.

If the performance is being affected by system and you think you can't gain any thing from query optimization...

I have run into some annoying issues when chaning compatibility mode from 80 to 90. But nothing major; how I did it on one of major systems I deal...

Sorry :(. I realized that after I posted it..

You can also refernece this document to see possible risks:

http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx

This article lists the issues you can run into...

Mike Levan (3/11/2009)

---

the same query again tempdb growed to 1 TB and i have to restart the service. can i restrict the growth from unrestricted to like 400GB? does it...

You'll have to capture the trace log to a file I don't see an option there to tell the trace log is in a table.. thanks.

Hmm try running a trace when you get a file directory? I was reading an article about SSMS for 2005 where it calls extended store proc to get that...

Hi,

To test the system against SQL Server Profiler Trace Log (I thought I was able to run this against just trace log, I was wrong .. :(...

Funny how...

A index scan is usually bad. But a book mark lookup is indicating that you don't have enough covering index for your query.

If you can attach your sql script and...

Few ways ....

1) If you have all the scripts for all objects.. then create new db run the scripts.

2) Backup database and restore on to production

3) Deattach-reattach to production.

If...