Viewing 15 posts - 1 through 15 (of 1,364 total)
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.
December 26, 2013 at 6:28 pm
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
December 26, 2013 at 1:48 am
Thanks Koen, any other way to speed up the process using bcp or any changes to import/export wizard..
November 28, 2013 at 12:08 pm
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...
October 26, 2013 at 7:54 am
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?
October 21, 2013 at 4:54 am
Besides building trusted domains, you also could use certificates for database mirroring. Here is an example of setting up database mirroring using certificates:
October 21, 2013 at 2:45 am
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 ->...
October 8, 2013 at 3:21 pm
You can refer the below link while troubleshooting.
Troubleshooting Insufficient Disk Space in tempdb
August 12, 2013 at 1:13 am
August 12, 2013 at 1:08 am
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...
August 12, 2013 at 1:04 am
another way to do that is to use openrowset or openquery function.
for more details you can follow these links
July 28, 2013 at 7:02 pm
Tested it too.
As Markus said unless you give select permission to either public or the user, they won't see any tables.
July 9, 2013 at 1:07 pm
Thanks for sharing the script guys.
July 9, 2013 at 12:50 pm
Please check whether login privileges are sufficient enough to run it and for information collection
July 1, 2013 at 6:31 pm
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....
July 1, 2013 at 5:32 pm