Because storage doesn't imply order. A view is simply an overlay onto storage.

Just like a table doesn't have an order, a view doesn't. Don't use views to preserve order....

You could set something up to look for the version in the sysobjects table, but as Jeff mentioned, there is no good way to look for when something changed.

If...

The log changes based on data changes.

You can copy off a log backup and then use Log Rescue from Red Gate (I work for them, the tool is free)...

Mike,

The name in the proc is irrelevant to your Call. You need to declare @dbname in your batch, not in the proc.

If I have

CREATE PROCEDURE getaddress

@dbname varchar(20),

@name varchar(4)

I can...

There's no way to do this. The change date isn't tracked.

I agree with everyone that you should only return what is needed and SELECT * might be a problem with future changes, but that wasn't the question.

The question is how...

I've used any of the above techniques. Third parties make the most sense unless you can dedicate someone to go to the bank or somewhere else every day and move...

As johan mentioned, a restart should fix things. Every once in awhile a kill hangs on the rollback.

Extra data can have an impact, but only in the data cache. SQL can easily handle 60GB of data in a few tables.

Are your tables indexed? They should be indexed...

That makes sense and just be sure that the subscriber isn't looking for a certain IP on the distributor if it pulls data.

Let us know if you have issues. We'd...

You could do something like:

create table #tables (table_name varchar(80), completed datetime)

insert #tables

SELECT TABLE_NAME, null

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE = 'BASE TABLE'

while exists (select table_name from #tables where completed is null)

begin

...

As mentioned before, the ordering of records is not guaranteed without an ORDER BY clause. If you want to display things in some order, be sure that you add a...

No idea, but I'll have to check. I hadn't put Cumulative Update 5 on my box yet.

This is one of the very annoying things about SQL Server. There are times, especially with the Service Packs, that it wants to put some stuff on C for the...

Don't stop reviewing! That breaks down the system. Instead I'd recommend setting up a hotmail or free account and a fake name and review them under another alias. At least...