May be your ODBC configuration is incorrect. The error clearly says invalid parameter check if you have given the right parameters and try creating the data source again.

You need to select this option only when encryption option is selected in your server so that data flow between the client and server will be encrypted.

sp_who2 active will list only the active users. you can use this.

http://www.sql-server-performance.com/awe_memory.asp

You can read about AWE options in the link given above.

You can have the database that your apps uses to use the collation instead of going for the server level default collation. You can create your database specifying the colllation...

I hope connection pooling is enabled. Can you try disabling that and see if the error occurs. Connection pooling might have been enabled for reasons so check before you disable...

Onw way is that you can set a max memory configuration to SQL Server so that it does not go beyond that limit. But when you say that your server...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=120&messageid=237238

The link above will solve the issue. Try and let us know.

Pavan,

My kind advice. You have posted your query as such and it has your user name and password...

SQL NATIVE CLIENT comes out with support from SQL 2005 and has better performance than the OLEDB provider for SQL Server.

Better its to drop and recreate the non-clustered indexes. Script all these indexes and recreate them on secondary filegroup. If possible place them on a different drive to enhance performance.

Use client network utility to specify that you always go with TCP connections. Then try connecting to the database using the TCP connection instead of shared memory. Check if error...

Logging off will close all active windows. I am not sure what you are trying to say. Logged off from terminal or disconnected. of disconnected then you process will go...

Colin,

Some clarifications from myside.

1. I have already said that all the columns in the join are indexed. I accept that there is no covering index but the columns included in...

SQL Server client network utility comes with the windows package and not with SQL Server one. Even if you have no SQL Server server/client installed in a machine you can...

As simple as it is. Create a windows batch file to do the same.

1. Use FIND command to find the file that contains your input string and write to a...