Server Configuration

TSX Servers Error Message in SQL Agent Error Log
I am getting the below error on all my Target servers on SQL Server 2005 SP2. They are a mixture of Standard and Enterprise Edition. My Master server is SQL Server 2005 SP2 as well. This only occurs when SQL Agent is restarted. I have tried defecting and re-enlisting, same error occurs. Message [419] Un... 10 Apr 2008 08:50

xp_readerrorlog error
i have the following error poping up. i can not also open error log from studio can open it with notepad however Exception happened when running extended stored procedure 'xp_readerrorlog' in the library 'xpstar90.dll'. SQL Server is terminating process 84. Exception type: Win32 exception; Exception code: 0xc0... 26 Mar 2008 13:31

copying stored procedures in SQL Server 2005?
Is there a quick way to copy a set of stored procedures in SQL Server 2005 from one database engine to another, as quickly as using DTS in SQL Server 2000? Other than restoring from a backup. Thanks, Dean S ... 5 Mar 2008 20:45

msdb
Hi I have a sql 2005 instance running sp2. The msdb database keeps running out of space and I cant work out what's using all of it. Currently its 1.5 data allocated. The usage report of the trables shows the larges table is only 10Mb! Any advise will be appreciated as to where to start looking. Thanks in... 15 Jan 2008 15:42

Database Maintenance Plan Wizard
I cannot run the DB Maint. Plan Wizard, when I trying I get the following error (right from the start): TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Unable to execute requested command.... 12 Jan 2008 11:56

SQL Server 2005 Error 5195
I was wondering if anyone has ever run into this error in SQL SErver 2005/ 2008-01-05 01:15:05.92 spid75 Error: 5195, Severity: 16, State: 1. 2008-01-05 01:15:05.92 spid75 The Cluster Service function call 'ClusterResourceControl' failed with error code '1008(An attempt was made to reference a token t... 9 Jan 2008 09:21

Table shows in Enterprises maganer But in Query Analyzer show "Invalid Object Name"
I am working in SQL7 and Table is exists in Enterprises manager But in Query Analyzer It show error "Invalid Object Name". I have type the correct name of the table. Can anybody help me this regard. From http://www.developmentnow.com/g/118_2005_10_0_12_0/microsoft-public-sqlserver-server.htm Posted via DevelopmentNow... 24 Dec 2007 13:16

SSMA error needs oracle client
Does anyone know why I getting this error when using MS migration assistance for Oracle tool 'Exception during processing: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater'? I have installed the oracle client 10.2 already. Any suggestion would be greatly appreciate. I have been ... 27 Dec 2007 02:30

question regarding slow performance an PAGEIOLATCH_SH locks on sql
The SAN setup is not necessarily a problem. Spreading the I/Os over as many spindles as possible is in general a good approach. There are three possible causes: (1) your SQL query is not efficient (e.g. bad plan), (2) you are I/O throughput limited, and (3) the performance is killed by the I/O latency problem.... 10 Dec 2007 11:55

question regarding slow performance an PAGEIOLATCH_SH locks on sql 2005
Hi, I wondered in anyone can help with the following problem that i'm experiencing, i'll try to provide as much info as possible and any suggestions would be appreciated. I have just started at an organsiation and there seems to be slow performance maybe on the san on a 64bit itanium dual core machine. 4 CPUs... 9 Dec 2007 22:37