Hey Lynn, I...

It is not a set period of time for reindexing and reorg. It depends on the fragmentation. There are quite a few threads here in SSC how you will be...

I think that was a good move Lynn. 🙂

I wish I could go to Pass or other SQL Group meetings in US. That is much more closer to me. But...

Chris Morris (3/24/2009)

---

Lynn Pettis (3/24/2009)

---

Is it me or are the people we are trying to help just getting dumber, or do we need to start commenting are code a lot...

Hahahaha Lynn, Maybe you should not have put Drop Table statements in the end. :hehe:

Maybe you should edit your post and state that you should not use the Drop Table...

Dagnamit, I loose that one as well.....:crying:

How many of you all travel to Europe for Pass?

Then I think I will win the Shortest Male here. 🙂

I dont travel to US because of all the hassle with Visa and all that. Its too much of head...

I guess I am the shortest here...:-) I am just 5'6". 😀

The chance of meeting anyone from THE THREAD is very remote for me since I am not in the...

Set up the replication for publisher with NOT for Replication and create the table in Subscriber as an INT or BIGINT without Identity specefication.

You can do a reinitialize data. Snapshot with Truncate in the Destination table to get this done.

What does the App actually do? Is it a place where they can write SQL's or is everything controlled by the Web App?

If it is just a normal application,...

Hi Steve,

It all depends on what these external users are going to do. Windows Authentication would be good to manage since you can put them all in a group and...

Arrogance has returned? In Rant you mean?

Hi ShankMonk, Got a question for you. When you say you want to refresh the Data from Prod, are you talking about different tables that are not replicated or are...

The answer is depends on the type of replication used. If it is a replication set up where both the Publisher and subscriber can get updates, then you will have...