Letron,

I do not know about views, but:

I currently use transactional replication to replicate data from numerous locations to a central location. The data comes from day tables, which are cleared...

Also, you can try to go to the live database and use SSMS to create a script to drop the publication then run it on the restored database.

MAK

In order to remove replication from this database, you are going to have to manually remove it, which is a multi-step process.

Please read carefully the KB: http://support.microsoft.com/default.aspx?scid=kb;en-us;324401

You will...

MAK - you need to first get those all set to 0.

See my earlier post

I the database that you are having a problem with run

Provide the results.

There are 2 options:

1. Run sp_MSunmarkreplinfo which takes a tablename as a parameter.

2. Alternatively, setting sys.objects to 0 in sys.objects for the particular table should do it.

Finally, running...

SQL Server 2005 and before does not compress it's dump files. In order to compress the dumps you need a 3rd party tool such as RedGate's SQL Backup. This can...

Statistics are always created at the same time as an index, and always as if FULLSCAN had been specified. SQL Server automatically updates statistics as the optimser needs them (by...

Arjun, when you create your indexes, the statistics are normally created for that index. I have seen major differences between statistics created on an empty table and on a loaded...

I will keep all posted if we do anything with this as well. Should be an interesting project.

Dave,

Thanks for the links. It appears that it is doable. Now to play.

Thanks Gail. That is why I called this a theory as well as strange. Just grasping at straws here, unfortunately as usual.

Gail, Thanks for the response. unfortunately, the simple answer is no. We would need additional equipment, to the cost of $22000.00 in order to do this per the hardware vendor....

Grasshopper - good lick. They are mimicking what the sales rep is telling them. What took a looooooooong time to prove was that the pools need to be seperated into...

I would definitely create my indexes/PK's after the data is loaded. That way the...