What you can try (no guarentee) is to change the collation of the model database. Since that is used as a template for new databases, in theory any new databases...

Thanks, I'll bear that in mind if this happens again.

I had to remove the replication this morning, as I was no closer to a resolution than yesterday and the...

What error did you get? Did SQL refuse to attach the db, attach but mark as suspect?

Check IIS and see if it allows anonymous access

Thanks. That's great

I don't think you can. I spent a day or so looking into exactly that issue. That long string of numbers and letters is a one way hash of the...

Detach the database, delete or move the ldf and then from ent manager attach database. The dialog will note that the ldf is missing. Click OK and db will be...

Could you give us more information? It this an existing replication setup? Are you configuring replication for the first time on these servers? If so, what have you done so...

Wouldn't that also pick up instances of #mytable created by other users?

How are you initially creating the temp table?

CREATE TABLE #myTable (...)

or

SELECT ...

INTO #myTable

I've had some problems with the SELECT ... INTO #temp before. Try explicitly declaring the table if you're...

Not unless you've got some form of datetime field that's set to the current date on an update.

Timestamp columns are updated whenever a record is changed, but I don't think...

Try an anonymous pull subscription. It's what I've had to do with a firewall between my distributor and subscriber.

Not elegant, but should work

SELECT *

FROM (Select * FROM TestWhereOrder WHERE TypeCode = 'N') NumericTests

WHERE TestWhereOrderID = 100

AND cast(Code as int) = 100

Create a database diagram with just that table. You can specify exactly what the diagram shows (just column names, names and types, etc)

You can print the database diagram

Very simplified down

i.ID, i.Header, i.Subheader, CAST(i.Text AS VARCHAR(200)) from Issues i

group by i.ID, i.Header, i.Subheader, CAST(i.Text AS VARCHAR(200))

Increase the size of the varchar if you need more chars (up to...