Are you able to post the code for the view and the actual execution plan?

How many distinct values of version make up the clustered key on the fact table?

Also using...

becasue '2d3' = 2000 as a valid float value so ISNUMERIC will return 1

SELECT CAST('2d3' AS float)

You are better off working out a decent size for your transaction log, AutoGrowth should only really be used as a fail-safe for unexpected log growth.

The size you set...

Are you able to post the table structure and some sample data?

It looks like you are going to have to write a for-each loop that loops through a recordset.

you can populate this recordet by querying your table that contains the table...

have a look at log shipping, this should work for you.

have a look at the error log on the SQL sever, this will give the reason why the login failed.

Why don't the tables have a primary key?

The best option for replication and for a relational database would be to add a primary key,

Failing this you could try and build...

do you have auto-growth enabled on TempDB?

it is possible to setup an alert but a pro-active approach may be better and you should size tempDB appropriately for your needs

have a look at the log of the Witness server, in there it should show when the connection to the principal timed out

mchofman (6/4/2010)

---

it is indeed a good idea to backup the logs more frequently, but when the logs grows over 60% between two backups it is a good idea to make...

Rather than set the backups to run when you are running out of space, you really should set them up to run at regular intervals and manage the transaction log...

I assume they are talking about the implicit conversion that would be required between datatypes in SQL 2000 and this can confuse the optimizer. This is for bit to...

There are a couple of issues with this query,

First you are trying to do the insert using VALUES, this means you should be stating what the value is where...

ThomasRushton (6/3/2010)

---

steveb. (6/3/2010)

---

ThomasRushton (6/3/2010)

---

You could do that, but...