Search Results | SQL Server Performance Forums

Does DST change affect SQL Server 2000

Thread by: rajeshraghavan, Jan 18, 2007, 1 replies, in forum: General DBA Questions

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...

LS copy fails randomly

Thread by: rajeshraghavan, Oct 12, 2006, 1 replies, in forum: SQL Server Log Shipping

Hi All, The log shipping copy fails randomly but it automatically corrects itself in the next copy cycle. I looked at the Windows eventlogs...

problem with job schedule

Thread by: rajeshraghavan, Jul 12, 2006, 3 replies, in forum: General DBA Questions

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....

Unlock a DTS package

Post by: rajeshraghavan, May 19, 2006 in forum: SQL Server DTS-Related Questions

Thanks a lot for the above link,<br />there is a batch file which has these two commands<br /><br />cl /nologo /c DTSConnPass.cpp<br />link /nologo...

Unlock a DTS package

Post by: rajeshraghavan, May 17, 2006 in forum: SQL Server DTS-Related Questions

Can somebody please help me with this? Raj

Unlock a DTS package

Thread by: rajeshraghavan, May 16, 2006, 6 replies, in forum: SQL Server DTS-Related Questions

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...

Problem Moving msdb and model

Post by: rajeshraghavan, May 5, 2006 in forum: General DBA Questions

I fixed it thnx for your help

Problem Moving msdb and model

Post by: rajeshraghavan, May 5, 2006 in forum: General DBA Questions

Thanks for the reply but I was following exactly the same document and the error is 17052. SQL server is not starting at all. I have moved msdb to...

Problem Moving msdb and model

Thread by: rajeshraghavan, May 5, 2006, 5 replies, in forum: General DBA Questions

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,...

process cubes and rebuild all dimensions

Thread by: rajeshraghavan, Apr 10, 2006, 1 replies, in forum: Analysis Services/Data Warehousing

Hi, Can I process all the cubes and rebuild dimensions from the command line; that is by executing a command. Thanks in advance Raj

To increase the job history

Post by: rajeshraghavan, Mar 22, 2006 in forum: General DBA Questions

Thanks a lot Satya Rajesh

To increase the job history

Thread by: rajeshraghavan, Mar 21, 2006, 9 replies, in forum: General DBA Questions

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...

problem with query

Post by: rajeshraghavan, Mar 16, 2006 in forum: General Developer Questions

PERFECT!!!!!!! Thank a million for your help Madhivanan.

problem with query

Thread by: rajeshraghavan, Mar 15, 2006, 3 replies, in forum: General Developer Questions

I am trying to monitor the length of a particular column called responsibility for the table positiontitle SELECT DATALENGTH (Responsibility) AS...

table records are missing

Thread by: rajeshraghavan, Feb 23, 2006, 2 replies, in forum: General DBA Questions

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...

How to transfer Jobs

Post by: rajeshraghavan, Feb 14, 2006 in forum: SQL Server DTS-Related Questions

To restore msdb always its better to stop SQL Server agent

How to transfer Jobs

Post by: rajeshraghavan, Feb 9, 2006 in forum: SQL Server DTS-Related Questions

There are so many ways: i)copy and restore msdb database that takes care of all jobs and dts packages ii)right click on the job script it as .sql...

DTS Package Logs

Thread by: rajeshraghavan, Feb 9, 2006, 1 replies, in forum: SQL Server DTS-Related Questions

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...

Communication between databases

Post by: rajeshraghavan, Dec 12, 2005 in forum: General DBA Questions

Thanks for the reply Rajesh

Communication between databases

Thread by: rajeshraghavan, Dec 9, 2005, 4 replies, in forum: General DBA Questions

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...