This is a good illustration of why you should always run adhoc updates inside a transaction.

If you see the wrong number or rows updated, you can just roll it back....

shew (8/24/2011)

---

Funny name. Never heard of it, but it looks very interesting. If I am reading http://forum.snitz.com/Forum/readme.htm correctly,...

Ninja's_RGR'us (8/22/2011)

---

Michael Valentine Jones (8/22/2011)

---

According to this link, all of the following upgrades are supported for both x86 and x64:

http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx

From:

SQL Server 2008 Enterprise Evaluation

To:

SQL Server 2008 Web

SQL Server 2008...

paul_ramster (8/23/2011)

---

That's the same algorithm I posted further up the thread, although rather better explained.

The only assumption that is made is that you know a Monday, which in your case...

According to this link, all of the following upgrades are supported for both x86 and x64:

http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx

From:

SQL Server 2008 Enterprise Evaluation

To:

SQL Server 2008 Web

SQL Server 2008 Workgroup

SQL Server 2008 Standard

SQL...

Timothy Batts (8/19/2011)

---

I'm having the same issue on multiple servers. All are in EST, and SQL logs, Agent logs, Database Mail logs, etc. ALL have correct date and...

The code to find the first Monday of the year is fairly simple:

First find the 7th day of the year (Jan 7):

dateadd(yy,datediff(yy,0,a.DT),6)and then find the Monday on or before that...

Have you double checked to make sure the backup job is being executed in the context of the service account, and not some user account that doesn't have access to...

Try changing this:

exec @proc @objname =

@TABLE_NAME ,@updateusage = 'true'

to this:

exec @proc @objname =

@TABLE_NAME ,@updateusage = 'false'

You won't have updated usage numbers, but the output should be reasonably accurate.

You...

You should consider moving to SQL Server 2008 (or R2) Enterprise Edition to be able to implement native backup compression, compression of the large tables in the database, and partitioning...

I think xp_cmdshell can be used securely if you take the trouble to set it up correctly.

The one thing that I don't like is that you basically have two levels...

Evil Kraig F (8/15/2011)

---

I'm confused here Jeff, nothing bad happens on May 31 + 3 months. August...

Your check constraint...

GSquared (8/15/2011)

...Assertion in an interview that threw me, "We have a lot of mission critical data, but it's okay to lose a day's worth of it because it would be...

Jason- (8/12/2011)

---

What color is your brain?

I said grey This was the question from the group VP. I had already nailed all the technical and soft skill questions,...