Alter database DBNAME Set trustworthy ON

Angela,

 I actually tried to create the jobs using the Enterpriser Manager. The Enterprose manager itself shows the time the job started "Last run time" there is a gap of exactly one...

Hi

The SQL Server7.0 is clustered and replication enabled...and the user account is in the local admin group, cannot change the service accounts to local

Levi

Thanks Kelly,

But we use ODBC and this does not seems to be the cause...anyway...let me know if you have something more on this..

Levi

"and has two 347 MHZ processors"

This seems to be the problem. No matter you do the most advanced performance tuning you will still have the problem unless you improve your...

Hi All..

With lot of hours spent running the load under different combinations it proved useless. The problem was a bug with Service Pack4 for windows. Microsoft finally gave us the...

Hi..

try to create a new task and try to manually execute..check whether its working...if not the problem could be with you SQL agent.

Modify your existing job which is not working...

Hi Ana.

Try the DBCC SHRINKDATABASE

( database_name [ , target_percent ]

[ , { NOTRUNCATE | TRUNCATEONLY }...

Hi..

Please truncate the transaction log before shrinking the Logfile..check the below command to do it.

dump tran Database_Name with no_log

Now use the dbcc shrikfile command.

levi

HI anil..

I was inquisitive when I saw your post..I tried out all sources but could not get what you want. To set a similar kind of alert, you need to...

Oops I could not understand your problem correctly. Is the 5.5GB file you are talking about is a database file?. If yes...check the Books Online for the command DBCC shrinkfile,...

When you say Stopping the instance it means stopping the SQL service using the service applet. or using the SQL server Manager. Thsi is not advisable. The Cluster Administrator monitors...

HI antare

Deleting is what we have been doing..but the problem here is the no of records...we will have around 4 million records by the end of the day and it...

Hi don

In my case too there are a series of jobs where the last step of each starts the next job in the series. But I have nearly 15 such...

Its SQL 7 and service pack 3...

Sorry we could not solve this ...we have gone for a OS reinstallation since we were running out of time...

These jobs call a VB...