Restarting the SQL Services will resolve this issue temporarily. However in the long run you may want to check the memory requirements or consider increasing the mem_to_reserve value.

The memory allocation depends on the load that SQL Server is going to handle. This article[/url] explains it better.

You may find these articles useful.

http://www.sql-server-tool.com/compare-two-tables.htm

http://weblogs.sqlteam.com/jeffs/archive/2007/05/02/60194.aspx

You created one more database? I did not get the question

Check if DSQUERY GROUP returns the same results as xp_logininfo?

That is a good approach. You may use this query to check for the fragmentation of the tables.

select object_name ( object_id ) as [Table Name] , index_id , avg_fragmentation_in_percent from...

The answer was available in the Hyperlink I provided in the previous post. You may query the default trace as per your requirement. However, I have given the below example.

select...

Both the links that I provided have "How to" do it information on Importing a custom DLL. If they are not useful then I might have misread the requirement.

You may want to go through the Default Trace of SQL 2005. This article[/url] explains on how to do it.

You may safely move that folder to some other location. In SQL Server 2000, there was a dependency on this folder, since it used to store the Outlook configuration used...

Is there any information in the Application/System Event Log when this exception occurs?

What does the four part query (ServerName.DatabaseName.OwnerName.ObjectName) return?

Does it throw any error?

You can transfer the existing data to a new table (after pruning the duplicate rows) using SSIS

I think the Linked Server is using an obsolete name (which was changed after adding the linked server) or it is configured for loopback. If needed you may configure that...

Since you are using Erwin data modeller check if your id has "Public" privileges on the database. If yes, then check if you are able to connect to the SQL...