Let's put it this way. Your disaster recovery is only as good as the last backup. You're capturing the logs once an hour. That means, in a really serious failure,...

2cams (4/27/2010)

---

Hi Guys, well the Tempdb is once again 36Gig on a 40Gig drive.

I ran this query

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM sys.dm_db_file_space_usage;

Free Space...

It's only 60,000 rows. That's not a trivial data set, but it's not that large. You should be...

First off, setting your transaction to read uncommitted and setting nolocks on the reads is redudant & wasteful. Second, just becaue you put nolock everywhere doesn't mean you can eliminate...

That's not even...

No doubt there are very good reasons to upgrade, but two years into the cycle and only, in theory, 18 months from the next version... waiting can...

The problem you're experiencing is very straight forward. Look at the documentation from BOL that I provided:

The columns that are being modified in the view must reference the underlying data...

You can update views, but there's a whole slew of restrictions around it. These are straight from the Books Online:

Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns...

Cool. Glad I could help.

I guess I'm confused, the job_id is right there along with the next run datetime. What else are you looking for?

If you need a literal breakdown of the schedule,...

Here's an explanation of the basic support schedule [/url]for Microsoft products. If you dig around on that site you can find the various products you're interested in. For example, here's...

This is right in MSDB: dbo.sysjobschedules

striker-baba (4/26/2010)

---

Thank you Lynn

That was apt solution for my problem..

I changer the recovery mode to simple and back to full and it worked gud..

one of my friend suggested me to...

I am very confused by this code.

I'm going to take a shot at what you're trying to do, but I don't understand why you're doing it.

Are you attempting...

itskumar2004 (4/26/2010)

---

Well i am trying to create a view in which there are two variables @a and @b-2 which will be coming from date table ,now how can i...