There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell.
2014-02-07
3,431 reads
A short procedure for your tools database. Use it to test connectivity to linked servers.
2010-12-28 (first published: 2010-03-19)
5,929 reads
THanks for your reply but No I just want to exclude them from my SP's output ...I am running it as a sceduled job directly into a file ... Any takers ?
2004-03-17
I am able to create the linked server but I am getting a message when I attempt to verify the tables or query the tables (files) The error is: Server: Msg 7399, Level 16, State 1, Procedure sp_tables_ex, Line 20 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: '\\Mhc_remote\Groups\mis\BHO\PREMIER\Pending' is not a […]
2003-07-24
1 reads
Thanks for your views on this, I haven't been thinking about how Yukon will affect this. The more I look into it the more I think the 2000 would be more appropriate for my current work and I am guessing that a lot of what I learn on 2000 can be taken to 2003 anyway, […]
2003-07-10
This is somewhat rough, but I think addresses your last question. SELECT syob.name 'ObjectName', -- syco.name 'ColumnName', -- syco.type, syob.type 'ObjectType', syus.name 'UserName' FROM sysobjects syob JOIN sysusers syus ON syob.uid = syus.uid /* If you want column data LEFT OUTER JOIN syscolumns syco ON syob.id = syco.id */ WHERE syus.name = '<username>' Regards, SJTerrill […]
2003-06-26
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers