I can see it as part of a PK if you do a lot of time range queries, but definetely not as the only column. The risk of rejected insert...

What I don't understand is why MS says onit's site

quote:

---

If you have applied SP3, you do not need...

I've seen this message before although I can remember the exact situation. My guess is that someone else holds a connection to the model datatabase or maybe you've selected the...

I've seen this message before although I can't remember the exact situation. My guess is that someone else holds a connection to the model datatabase or maybe you've selected the...

quote:

---

quote:

--------------------------------------------------------------------------------

I'm mainly a MS SQL Server guy, but I toyed around a bit with a pretty interesting databse called Caché from Intersystems....

It might be a stupid question, but did you configure publishing on your server?

Also run a profiler trace to see what is actually happening.

Oops, I forgot the place the link to the document.

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b260182

I'm not sure if you're doing this in EM or Query analyzer, but there is a problem if it's the first restore your doing and you use EM. Check out...

I finally found the time to come back to this problem and I found a document from Microsft confirming that this is a bug in SQL 7 and 2000. There's...

Jan,

you're right about this option, but technically it's not replicating the UDD's. So you still have to script your data types and create them on the subscriber.

Quest-Software has a tool called DataFactory which creates testdata.

http://www.quest.com/datafactory/index.asp

Best way to do it is create "Pending deletes" tables. Create a copy of your tables by generating a script and add a insert option to your triggers which inserts...

As far as I remember, you can't replicate user defined data types or defaults. You need to create them at the subscriber. Best thing is to create a script and...

Thanks for the replies. It's good to know that someone else get's the same result.

I'll try to get the hotfix but to be honest I doubt it will help. Anyway...

First the alert triggered is one of the demo alerts, which are created during SQLServer installation. There are demo alerts for all error with a severity level of 19 or...