Viewing 15 posts - 8,041 through 8,055 (of 9,253 total)
Paul
Good link. As Slava points out though the memory release process can be very slow especially under pressure. For that reason I, like others, err on the side of caution...
April 24, 2010 at 2:02 am
What does the following query produce on each server? Can you post the results?
select serverproperty('Collation')
April 23, 2010 at 3:13 pm
2 words, Regional Settings!!
The default collation out of the box is dynamic 😉
The collation is defined by the regional settings on the server, you can change but if you accept...
April 23, 2010 at 2:51 pm
is there a firewall in between the IIS server and the SQL Server?
Can you ping the SQL Server from the IIS box?
Can you telnet successfully to the SQL Server instance...
April 23, 2010 at 2:47 pm
if you're wise you will setup a test system first and test this thoroughly. The jump from SQL7 to 2005 is huge and the database compatability level will possibly not...
April 23, 2010 at 2:44 pm
i have experienced backing up SQL Server databases using DPM and i gotta say i'm not a great fan of the product at all. I use Redgate SQLBackup to backup...
April 23, 2010 at 2:37 pm
you want to ensure the OS has at least 4GB to manage the process memory efficiently
April 23, 2010 at 2:32 pm
Guys
just checked my SQL Server 2008 Ent x64 instance and guess what?? Yep, you got it, it's the same as yours
April 23, 2010 at 8:40 am
open the database diagram and right click then select copy to clipboard. Once on the clipboard open your favourite image editor Paint.net and paste into a new image
April 22, 2010 at 7:08 am
emily-1119612 (4/21/2010)
I gave up on xp_delete_file.
it does work extremely well if you take the time to get to grips with its parameters
April 22, 2010 at 6:01 am
karthik -450760 (4/21/2010)
I tried to login to the server through Remote desktop connection and I got the error message ,
" The account is configured to prevent you from...
April 22, 2010 at 5:58 am
CirquedeSQLeil (4/21/2010)
But can the OP logon to the same server that is having the problems with that user account?
is why I suggested login to server if account or domain is...
April 21, 2010 at 3:08 pm
My reply says logon to the server not SQL server 😉
the best way to check an accounts validity is to logon to the server, true it doesn't have to be...
April 21, 2010 at 2:54 pm
firstly logon to the server with the account details and verify success.
Next, change the service account info and enter the new password via SQL Server configuration manager
April 21, 2010 at 11:28 am
Subversion is a great source control product, highly recommend it!
April 21, 2010 at 11:26 am
Viewing 15 posts - 8,041 through 8,055 (of 9,253 total)