They're not the same thing, but they are similar.

In basic terms, a log backup is the backup of changes (transactions) since the last backup. An incremental backup does a...

NewBeeSQL (3/3/2010)

---

One more question which i missed in Original Post..

Does it require to have an index on FK columns. can any one please post possitives and negatives of having an...

You're welcome

Jack Corbett (3/3/2010)

---

john.arnott (3/3/2010)

---

RBarryYoung (3/2/2010)

---

Paul White (3/2/2010)

---

And I would (genuinely) guess at Chicago. But why ask about the Bears?

It's a meme isn't it. I was...

I have a bunch of certifications. Nothing since MCDBA 2000. I did a lot of cert testing early on due to working in environments where it was a...

vbprogrammer1986 (3/3/2010)

---

I Want a Backup copy of that portion of data which is change since last any type of backup(full or differential).what is the name of this type backup? may...

Blocking would not be normal. As described in that link you found,...

SQL 2005

Select s.name +'.'+ o.name as TableName,o2.name as FKName,c.name as FKColumn

From sys.foreign_key_columns fk

Inner Join sys.objects o

On o.object_id = fk.parent_object_id

Inner Join sys.schemas s

On s.schema_id = o.schema_id

Inner Join sys.objects o2

On o2.object_id =...

To disable

select 'alter index '...

janiet (3/3/2010)

---

Can anyone please post or send me a project plan for an upgrade 2000 – 2008 and a project initiation document , test plan etc . many thanks in...

Check out this article for some tips

http://msdn.microsoft.com/en-us/library/cc966412.aspx

Each environment will be different. You should test your system, baseline it, and then trend it over time.

Classic "It Depends" dilemma. I sit the fence on this one because there are scenarios where one is obviously better than the other, and vise-versa - for the customer....

Steve is correct about the browser, port and using an FQDN makes sense.

The below article has a series of Q and A on the topic.

http://www.sqldev.org/sql-server-reporting-services/how-to-assign-a-role-to-user-through-ssrs-web-service-21500.shtml

I have seen Microsoft questions with just as much detail as this. Assumptions still had...