Jason, I appreciate the suggestion, but it did not work for me. I moved it over to a windows system account and that still will not allow non-sysadmins to...

Jeff Moden (7/29/2008)

---

timothyawiseman (7/29/2008)

---

Heh. They also help people who don't know how to READ sql (some of the recursive features can be convenient at times too.) We have...

Heh. They also help people who don't...

Thanks, Vinkat.

Thank you. This saved me the trouble of writing something like it.

Incidentally, it does not get rid of defaults if you consider those constraints.

Chuck Rivel (7/23/2008)

---

personally, i would walk through the import\export wizard within the database where you could setup either straight table mappings between servers or write a sql query. Both options...

HYDNIZ (7/24/2008)

---

I added a parameter to SP. For a different value, only one SQL statement get executed. All sql statements are going against same tables. What is puzzling is...

There should be no significant difference that I am aware of when running them as a stored procedure or as individual statements. In certain cases it can affect whether...

I thought it was a very interesting article with an interesting concept.

One note is that there is a set based way of generating the helper table that may...

As Jonathan points out, this needs a lot more detail for a full evaluation and having some execution plans to look at helps substantially.

However, there are many cases...

Thank you both, I found it immediately by right clicking, and the functionality is definitely greatly improved.

Mike Good (7/17/2008)

---

Darn. Well at least 2 of us have come to same conclusion.

When we start using "WITHOUT LOGIN" users we're going to have to abandon notion of...

select

name, recovery_model_desc

from

sys.databases

Will do it in SQL Server 2005. I do not have a SQL Server 2000 instance handy to test it, but I believe:

select

name, recovery_model_desc

from

dbo.databases

will...

blandry (7/17/2008)

---

Great article, and thanks for it - but under the heading of "the more I learn the less I know"...

Is there really any difference or advantage between Temp Tables...

Well done article. Thank you. I initially anticipated discussing all 4 types of backups at the same time, but what is present is well done.

Incidentally, for any but...