I am trying execute stored procedure in remote server in sql agent job using sqlserver 2008 r2 select * from openquery([126.96.36.199],'exec [DB_Name].[dbo].[sp_ProcName]') Or EXEC ...
I would like to create a SQL Server agent job that would run every 10 minutes. The job would check for new records in a table on a remote database (linked server already created), if exist the job ...
While connected to our production server (SQL2008. very powerful machine), this select statement takes 2 seconds, spitting back all fields (4 MB of data in total). select top 30000 * from person ...
I'm working with MSSQL Server Management Studio 2008 and I need to expose a view to a third party for their data reconciliation. I have created the appropriate view but I'm having trouble creating a ...