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...

I used to work for a company that was not so enlighted. You could not work from home remotely. 🙁

Hopefully, the company I work for now will...

Matt Miller (10/3/2007)

---

You could also just try to see if the shortcut went bye bye. Just double-check to see if you HAVE a ssms.exe file on the system or...

EdVassie (9/7/2007)

---

The install media for SQL Server 2005 is split into 2 - a Server folder and a Tools folder. If you do a server components install the tools will...