Viewing 10 posts - 16 through 25 (of 25 total)
Yes the query gets executed successfully from SSMS apart from the third step where I get error Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to...
June 28, 2016 at 8:25 am
You mean to say like this.
JDBC URL: jdbc:sqlserver://srvrname.dbms.sqlservercentralcom:10000;SelectMethod=Direct;DatabaseName=TEST
??
June 23, 2016 at 8:41 am
Yes I have tried backing up keys and its good. No issues over there. I am looking out for a cause why its happening.
June 16, 2015 at 8:43 am
No there was no migration of report server DB's. It was implemented here on this server and its not a DEV -> PROD migration.
June 16, 2015 at 6:17 am
Yes I do have monitoring SCOM. But still from my side if I have some scripts it would be easy to extract the reports. Can you kindly share the scripts...
March 23, 2015 at 9:53 pm
I use 32 bit os. Yes referred the links. Start-RUN-ODBCAD32-System DSN- Click Add- the driver DB2OLEDB is not appearing. Will this be an issue. However the same appears on SSMS-Linked...
November 18, 2014 at 8:18 am
Yes I am connecting DB2 server. I have SQL running on 1433. I have installed the DB2OLEDB provider in the server and gave the provider as Microsoft OLEDB provider for...
November 18, 2014 at 7:58 am
The below is linked server i created. Its OLEDB DB@ provider.
USE [master]
GO
/****** Object: LinkedServer [ECCVPDB] Script Date: 11/18/2014 5:43:18 AM ******/
EXEC master.dbo.sp_addlinkedserver @server =...
November 18, 2014 at 6:44 am
The below is the script that i used for creating linked server. Kindly let me know how to resolve this issue.
USE [master]
GO
/****** Object: LinkedServer [IBASE] ...
November 18, 2014 at 2:18 am
I could not see the logs any. When I right click replication monitor I can see Perf monitor distributor property
March 5, 2014 at 8:38 am
Viewing 10 posts - 16 through 25 (of 25 total)