** edit -- posted while you were posting the real code **

Can you post the original code so we can actually see what you were doing and propose a solution...

Can you post your .NET code? Do you have SSMS Express installed and, if so, can you run the backup from the app machine using SSMS Express?

Terry (5/13/2008)

---

Actually the update statement is a bit more complicated.

Let's say that i get the phone number from another embedded select (that's why i put values likes XXX and YYY).

The...

Looks to me like you just need 1 update statement in a stored procedure like this:

[font="Courier New"]CREATE PROCEDURE update_phone_no

   (

   @id INT,

   @phone VARCHAR(15)

   )

AS

UPDATE Clients

   SET phone = @phone

WHERE

  ...

LocalSystem would be the default and should not cause the non-connection issue. Is IIS running?

I have not used the CLR as yet, and have not really seen a compelling reason to use it. I try to avoid situations where strings need to be...

On the job step you can specify a number of times to retry a step on failure along with how long to wait between retries. You really need to...

Let me make sure I understand your issue, you have a full db backup and a single file with 175 log backups since the full backup. What your code is...

One way would be to generate a random number, see this thread for one way, and then use start_date = DateAdd(day, random_number, getdate()) and end_date = DateAdd(day, random_number + 1,...

Can you post your application's connection string? Changing sensitive information of course. I ask because the error you are getting is telling me that you are attempting to...

Is this SQL Server 2005? Did you tell Reporting Services to start during the install?

You need to go to SQL Server Surface Area Configuration -> Configuration for Services and...

You are right it is messy. There is a lot going on here, can you provide a brief explanation of the business rules for the code? I also...

You use the Error data path. The only thing I can think of is that you need to Configure Error Output for the Transformation task and set it to...

What about the autogrow for the log file? With that many writes the log file is likely to grow often and if on the same drive as the data...

According to sp_spaceused you have 4GB of unallocated space in the database. In BOL under DBCC ShrinkFile iit suggests running:

[font="Courier New"]SELECT

   name,

   size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS INT)/128.0...