Expand the "Management" and "SQL Server Logs" tree in SSMS. You will see all logs available. The date/time value indicates the moment of the most recent entry in that log.

If...

I think if you can speed up the update by using the row_number function:

-- display rownr's assigned to each 'block' of similar rows (only for display purpose)

select row_number() over (partition...

The description is telling you what to do:

Apply SP1 to your Visual Studio 2008 installation.

Of course: the best way is to design the table/columns in a way that strings and numeric values are not in the same column.

But I guess you just have to...

First I would try to determine...

According to your original post, you also need to apply both SP3 and CU1 of SP3.

N Nara (8/21/2013)

---

One of the options that I am thinking off is to take the backups to a local drive and have a file copy to move files from SQL...

Your database desing could be normalized. In the current design there is a lot of duplication. Consider to design the tables as follow:

Add a ID column to dbo.newtable:

newtable_ID, software_manufacturer,productname, productversion

Add...

It's not required to apply the -latest CU-. It required to apply the -latest...

The execution plan would be a good start, but I can imagine that this would be difficult to read with such a large stored proc.

But why don't you want to...

ananda.murugesan (8/21/2013)

---

Ok..

That error was fixed with CU6 of SP3.. SQL SERVER 2008 32 bit

Pl. confirm as below steps for updating SP3 and CU6

1. Install SP3

2. Install CU1, CU2....CU6 ( i...

According to your stated requirements, record (2, 8) from table [tbl_PersonDetails] should also be in your resultset. The value 8 doesn't fall between 12 and 15.

This code uses an INNER...

The error message states the destination path can not be reached. This indicates problems on the network or on the SAN level.

There could be too little bandwith or too much...

You mention the instance is installed on a cluster. In a cluster you need to start the Agent Service by starting the SQL Agent Cluster Resource in Cluster Administration.

I don't know if the SP and CU will solve your problem. But it's always a good thing (for both security and stability) to apply the latest SP to your...