Hi All, We are having SQL server 2000 Enterprise Edition database. There is a Day Light Savings (DST) change in US from April to MArch. Does...
Hi All, The log shipping copy fails randomly but it automatically corrects itself in the next copy cycle. I looked at the Windows eventlogs...
Hi All, I have a job scheduled every minute from 12:15AM to 11:59PM. There is a new schedule being added from 12:00AM to 11:59 PM randomly....
hi, I need to unlock a DTS package which the developer has locked with a password and has quit the job. I checked sysdtspackages table but...
Hi, I am trying to move the msdb database, I am following the MS technet document. I have added trace flag "-T3608" to startup parameters,...
Hi, Can I process all the cubes and rebuild dimensions from the command line; that is by executing a command. Thanks in advance Raj
Hi, IS there any way where I can increase the job history in the sysjobhistory table. Currently it has the history for only 24 hours. Please let me...
I am trying to monitor the length of a particular column called responsibility for the table positiontitle SELECT DATALENGTH (Responsibility) AS...
I am trying to troubleshoot an issue where three of our table records were wiped out completely. I examined the Windows eventlog and SQL server error...
Hi, Though I have enabled "Log packege execution to SQL Server" option in package propeties I am not able to see the logs of that package. The...
I have a question : There is a database A and Database B, if stored procedure in A is querying a table in database B, How is the connection between...
Hi, I have a LS setup which fails with this error which is in LS history: [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4330: [Microsoft][ODBC...
Hi Just have a quick question about log shipping, We have Server A shipping logs every 15 minutes to Server B, Now can SERVER C also ship logs to...
Hi, Is there a way where the DTS packages mails automatically when it fails. I know the way where we use in DTS designer execute package and then...
Hi, When i execute exec xp_sendmail '<email address here>', 'Testing' I get the following error message Server: Msg 18025, Level 16, State 1, Line 0...
Hi, I have configured email and page alerts if a job fails. When the job fails I don't get the emails as well as the page message. When I right...
Hi, I have a scheduled a automated reboot of the server everyday through NT Scheduler. After OS is restarted, SQL Server is starting starting and...
Hi, How to schedule jobs for archiving and restoring databases in MS Analysis server? Thanks in advance Rajesh
Hi, I have a table which has 300,000 records, and is there anyway where I can delete the rows of the table upto a particular date. i checked...
ITs erroring saying unable to locatethe installation file 'C:program filesMicrosoft sql serverMSSQLUninst.isu'. Uninstallation will not continue....
Separate names with a comma.
