Viewing 15 posts - 76 through 90 (of 335 total)
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...
April 22, 2009 at 4:01 am
(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....
April 22, 2009 at 3:59 am
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...
April 17, 2009 at 4:15 pm
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...
April 17, 2009 at 3:42 am
Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
Did you
- tried to ping the servername from the...
April 15, 2009 at 5:22 am
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),...
April 6, 2009 at 9:14 am
That warning is pretty straight forward. Somewhere in the code a string is getting placed that's just too long.
Yes, I know the meaning of this error, but why is the...
April 6, 2009 at 8:02 am
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...
March 31, 2009 at 4:15 am
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...
March 26, 2009 at 2:46 pm
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...
March 23, 2009 at 7:06 am
yes, memory settings are for physical memory (otherwise you'll get an "financial" crisis on your database server too 😀 )
March 17, 2009 at 4:39 am
- 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...
March 17, 2009 at 2:50 am
Yep, and that's not what I want.
Btw nice (new) picture of you, I didn't know you had a beard 🙂 😀 😛
February 20, 2009 at 8:24 am
Congratulations! Still one of my favorite MSSQL resources.
Wilfred van Dijk
Database administrator
GEA Refrigeration IT Services B.V.
January 29, 2009 at 7:16 am
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...
January 20, 2009 at 6:36 am
Viewing 15 posts - 76 through 90 (of 335 total)