Thanx Vlad.

Now here's the interesting part.  How is david gonna highlight that space in red without using an underscore ?

I'm sorry David but I just don't see any difference between the 2 statements.  Care to highlight it for me?

Ya and there are many other ways to update the text of the stored procs / views... without going to that extreme.

What do you need to do exactly?

I think you got most of them...

So what were those top 10 newbie questions (from the top of you head)?

Let's try to fix the forum and repost my message :

Same here.  It made me relie so many memories.  Thanx for the great article.

Thanx for the confirmation... but I knew that my source was extremely reliable on that one .

Same here.  It made me relie so many memories.  Thanx for the great article.

I second that .

Yup.  that can happen if you need to keep "deleted" data in an archive table or even in the main table.

This code is just to have a demo table and data to show how the query works.

You don't actually need to reinsert any data in the table

This compiles and executes just fine on my server :

IF EXISTS (SELECT * FROM MASTER..SYSDATABASES WHERE NAME = 'FakeDB')

begin

 EXEC FakeDB.dbo.SomeProc

end

The shrink database can work if there is free space in the files.  But in my last case I had 15 GB of data in the log for a 250 MB...

Nope... I'm just telling you what I took for me to get it working.  I'm sure there are other ways but I'm in no way an expert on that matter.

...and sp_helpdb just gives you the info that you see in the database properties.

As I understand it :

first backup creates a starting point.

log backup creates a second point, but since some new transaction can be...