Mani Singh (6/25/2008)

---

Go with the first approach of changing the size of datatype, but avoid using MAX it is a BLOB type equivalent to text in earlier versions.

so use it...

Steve, in your editorial you said,

"TechEd is still disappointing for me this year, with about 6000 people instead of the 11,000+ there has been in the past. That many people...

OK, that was it. WOW, I feel so stupid; the answer is so obvious.

Oh well, thank you everyone for helping me out of my brain fart.

Thank you for the feedback everyone. I didn't realize that the format they were using was an old SQL standard (with *=, =* and so on). I'll try...

WOW, thanks Antonio and SteveB! Your two answers gives me exactly what I'm looking for and now I can make an informed decision. I really appreciate it!

OK, thank you, Scott.

Scott, what did you do to fix it? Did you run DBCC UPDATEUSAGE?

Thank you, Grant.

Prasad Bhogadi (1/28/2008)

---

Hello Rod,

Thank you for the comments, I see what you were doing! You tried to generate the stored procedure for a table that has no Identity defined and...

I copied the script off of the page, and pasted it into a Notepad++ buffer to look at it. One thing that was kind of odd were the strange...

Freddie (1/8/2008)

---

In the UK we have employment law, where your employer must have a good reason to fire you. I can't imagine any tribunal agreening that a teacher should...

The article you pointed to on CNET ("How to loose your job on your own time") is no longer available. Can someone who has read it, please summarize it...

We're using Full for the recovery model in SQL Server 2005. So, does that mean that the log file won't be truncated when a backup occurs?

In our test database...

I don't typically play any sort of computer games. I've never own a game console or anything. For an IT guy, I am an exception.

But in those rare...

OK, then, it seems to me as though my only course of action is to uninstall SQL Server 2005 and reinstall it again.

Will that also take off SP2 for SQL...