Yeah actually I had over looked that yday and I fixed it. thanks peter.

Thanks guys, I ended up finally in editing the registry using regedit, adding the startup paramater manually and then successfully started my database. The earlier problem was like when I...

Justin,

It might happen due to a couple of reason.

1. The disk might be running out of space.

2. The transaction log might have filled.

You can add the error log or...

No Problem I got it fixed. That was a space issue in the distributor. I tried to set up an error output file and now its working.

I hope there is no need to go to advanced options since in that you will find options to create fail over node and blah blah. you have to proceed...

If that is not properly delimited by a delimiter its not possible to import data from a text file using sql server.

with smiles

santhosh

Hi Preethi,

Can you check whether the user is having proper permissions. Mostily this error will occur due to permission problems. If you have more than one domain verify whether the...

I have faced a similar kind of situation like this. I resolved it like I will sent out a file to a particular folder and one windows process will be...

That is the problem. The DTS does not fail each and every time. It fails once in a while. Any other method to catch that culprit causing dead lock

with smiles

santhosh

Hi,

Each and every job has an notification tab, in that you can specify the mode of notification and also the option there exists to notify using email try that..

with smiles

santhosh

check whether the path exists in the place where ur trying to restore the database.if it does not exists then put the new path for the database and log file...

Interestingly this query takes much time to execute

DATEDIFF(hour,createdate,@SQLSelectBeginDate) = 0

than the below query

Where DATEPART( yyyy,

CreateDate ) = @SelectYear

AND DATEPART( mm, CreateDate )

= @SelectMonth

AND DATEPART( dd,...

Hi Guys,

 Thanks for your reply I got some other solution for this problem as given below.

DATEDIFF(hour,cast(createdate as datetime),cast(@SQLSelectBeginDate as datetime)) = 0

HTH

with smiles

Santhosh

Works great thanks.

No, I did not run that SP but when I tried to use the sp_addserver, it says server already exists in that name.