Sorry, my answer is for user databases, I didn't read your question quite well. So my answer is for user databases with a different collation.

BTW you can create a database...

(step 1) You can change the collation, by changing it in the database properties, but ...

(step 2) all the tables in the database with varchar/char/nvarchar columns have the original collation....

We started this discusion, because we had a terrible delay in our Axapta application on some forms. My colleguae was pointing to the mirror commit overhead (5-10 ms) because that's...

Unless you have installed some triggers, it's almost impossible te determine who did the job.

Instead of looking for the person who did this, I suggest to focus on getting the...

Did you

- tried to ping the servername from the...

Found the bug!

In my processlog, there's a column called username, default suser_name()

It was defined as varchar(30), but it's returning nvarchar(128)

My SQLservice account is quite a long name (including the domain),...

Yes, I know the meaning of this error, but why is the...

Mirroring is, like its name, a realtime copy of a database on another server. Where clustering is a mechanism for catching a complete servercrash, with mirroring you'll have the possibility...

After reading some articles about SQLCmd, I found a solution by setting a variable to either "with encryption" or a blank space. It's something like this:

prod.sql:

:setvar encrypt "with encryption"

:r c:\temp\myproc.sql

myproc.sql:

create...

It's a misunderstanding that the logfile is small under SIMPLE recovery. It seems a large transaction is running in a job. As long as there's no commit, undo information is...

yes, memory settings are for physical memory (otherwise you'll get an "financial" crisis on your database server too 😀 )

- AWE is not needed for 64bit OS, it's only a window for 32bit OS to address more memory

- As mentioned, enable 'lock pages in memory' on 64bit OS

- If...

Yep, and that's not what I want.

Btw nice (new) picture of you, I didn't know you had a beard 🙂 😀 😛

Congratulations! Still one of my favorite MSSQL resources.

Wilfred van Dijk

Database administrator

GEA Refrigeration IT Services B.V.

Stange, your example works for me:

1) The email is sended correctly

2) I got a (valid) link by email

3) when I open this email, I can click on the link

4) explorer...