Better use profiler to find out the login source. You may also check default trace files to check the program name from where its originating.

Better give this one a try though an undocumented function is being used here:)

SELECT p.spid, j.name As 'Agent Job Name',*

FROM master.dbo.sysprocesses p

JOIN msdb.dbo.sysjobs j ON

...

Thanks Koen, any other way to speed up the process using bcp or any changes to import/export wizard..

Is any other process running on server in parallel. I hope you have the instalables placed on local drive rather than on network. Hows the cpu usage and memory utilisation...

Please check error logs of sql server for any unusual entries. Also, did you apply any service pack in recent past and this problem popped after it?

Manu

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e2363a0b-913c-409f-b84e-c4d977044785/db-mirroring-in-sql-2005-2008-across-different-network-domains-

Besides building trusted domains, you also could use certificates for database mirroring. Here is an example of setting up database mirroring using certificates:

http://technet.microsoft.com/en-us/library/ms191140.aspx

HTH!

MJ

I hope you already checked http://www.sqlservercentral.com/Forums/Topic1102363-291-1.aspx#bm1115040

Please ensure you have Automatic configuration turned off and proxy server disabled in Internet Explorer. Internet Explorer -> Tools -> Internet Options ->...

You can refer the below link while troubleshooting.

Troubleshooting Insufficient Disk Space in tempdb

http://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspx

Refer http://www.sqlservercentral.com/Forums/Topic687763-291-1.aspx

SQL 2005 -> SQL Server Setup requires Microsoft Windows Installer 3.1 or later and Microsoft Data Access Components (MDAC) 2.8 SP1 or later.

SQL 2008 R2->SQL Server Setup requires Microsoft Windows...

another way to do that is to use openrowset or openquery function.

for more details you can follow these links

http://sqlblog.com/blogs/buck_woody/archive/2010/03/16/using-linked-servers-openrowset-and-openquery.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=140963

Tested it too.

As Markus said unless you give select permission to either public or the user, they won't see any tables.

Thanks for sharing the script guys.

Please check whether login privileges are sufficient enough to run it and for information collection

Here are couple of common ways to access the SQL Server Browser service.

•Through Windows Services MMC. Access Windows services through the control panel or enter services.msc in the run box....