Recent content by hgrick

Hi, I'm trying to convert varbinary to numeric data type and getting below error message Server: Msg 8115, Level 16, State 6, Line 1 Arithmetic overflow error converting varbinary to data type numeric. Here is the script I'm executing: print cast(0x635B3441797440B6920AB1C443363A46 as...

You can install SQL Server client tools on your local desktop or laptop and then open enterprise manager, register that sql server which has jobs, and start the job right from your desktop

Hi, What is the SQL Server version and Service pack that you are using? do u have outlook client installed on that server?? http://support.microsoft.com/?scid=kb;en-us;281293&spid=2852&sid=global

The MSrepl_errors table contains rows with extended Distribution Agent and Merge Agent failure information. This table is stored in the distribution database.

pl check on which port sql server is listening to? default is: 1433. can you try using ipaddress,port number ? (Ex: Data Source=190.190.200.100,1433;)

I've the same problem and i tried this : while creating ODBC connection on the client machine, Open ODBC DATA SOURCE ADMINISTRATOR CLICK ON user dsn tab click on Add select SQL SERVER and click on finish On the 'create a new data source window' fill the name, description and server columns...

try enabling Trace flag 1807 on that server