/* OPEN QUERY LINKED SERVER HATASI Open Query sonucunda aşağıdaki hata lınırsa Aşağıdaki hata alındığında diğer işlemlere sırası ile devam edin. Msg 7411, Level 16, State 1, Line 1 Server ‘SERVERNAME1' is not configured for RPC. This means that when I set up my linked server, I disable RPC commands to and from running for security reasons. */ --When I run a simple command to view the error log from my linked server: exec [AYT-00-SQL-T102].master.sys.xp_readerrorlog -- To re-enable the RCP commands for the linked server: exec sp_serveroption @server='AYT-00-SQL-T102', @optname='rpc', @optvalue='true' exec sp_serveroption @server='AYT-00-SQL-T102', @optname='rpc out', @optvalue='true' /*Once RPC is enabled, there are a couple of other command I like to run to find out the health of the SQL instance & its databases. – This extended stored procedure displays operating system information regarding local attached disks: */ exec [AYT-00-SQL-T102].master.dbo.xp_fixeddrives --This stored procedure displays the size of the database and how that space is currently allocated. exec [AYT-00-SQL-T102].OdeonAntalyaIncomingTest.dbo.sp_spaceused --You can run DBCC CHECKDB and other DBCC commands over a linked server connection: EXEC [AYT-00-SQL-T102].OdeonAntalyaIncomingTest.dbo.sp_executesql N'DBCC CHECKDB'
