Friday, January 30, 2009

553 Message filtered

553 Message filtered

This Erro states that your emails are filtered by Spam Filter.

I suggest you to follow these steps below.


1) Check if your Email server' IP address is in Blacklists.
http://www.dnsstuff.com/ or http://www.mxtoolbox.com/

If your IP address is in blacklist(s) . Contact them to remove your address and try sending emails to domains that you get this error after 24 hours.

2)Check if your Email server is open relay.http://www.abuse.net/relay.html

3) Check if your emails contain SPAM content.

Don't ever send more then 250 emails concurrently to AOL
Don't EVER embed an image in an email
Don't use caps anywhere in your email, especially in your subject line
Don't send an email without checking your Spam trigger word content**
Don't use the word "remove," use "unsubscribe"
Don't start your subject line with "Dear..."
Don't use Spam software to send email
Don't use your PC as a server
Don't forge headers
Don't put ADV in your subject line
Don't send an email without checking to see if you or your ISP is on a Blacklist**
Don't over use punctuation (just one !)
Don't leave headers blank
Don't use BCC to send emails (and certainly not CC)
Don't over use Marketing Phrases**
Don't use the Priority option
Don't change the time on your server so your email stays on top of the heap
Don't overuse HyperLinks
Don't use a fake IP address to send email
Don't use HTML (sorry)
Don't waste time sending email without using e-filtrate ;) e-filtrate is an automated system that makes sense of all this.

source : http://www.e-filtrate.com/

4) Check your email server for virus or malicious software that can send SPAM


Read more...

Prevent Domain Group Policy's from applying Administrators or other specified account...



Open Active Directory Users and Computers console. Right Click the domain or organizational unit that group policy is applying.
Choose Group Policy from screen.
Right Click releated policy and choose properties.
Choose security Tab. If the user that you want Group Policy to not apply is not in the list Add user by clicking Add Button. After adding user be sure that Apply Group Policy permission is in the deny state.
Then Group Policy will not be applied to specified user.
Read more...

If sometimes your SQL 2005 server responds slow to your queries....

There can be many reason that cause your SQL server to respond slowly to your queries.(Disk I/O , RAM ,CPU....) If you believe that your hardwares have aduquate values, try stopping SQL 2005 trace process and test your queries again.

exec sp_configure 'show advanced options' , 1
reconfigure
exec sp_configure 'default trace enabled', 0
reconfigure
Read more...

Query that shows TOP 10 most CPU using queries...

SELECT TOP 10 total_worker_time/execution_count AS [Avg CPU Time],
SUBSTRING(st.text, (qs.statement_start_offset/2)+1,
((CASE qs.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE qs.statement_end_offset
END - qs.statement_start_offset)/2) + 1) AS statement_text
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
ORDER BY total_worker_time/execution_count DESC;
Read more...

If your SQL 2005 log file is too big...

We can reduce log file size by using shrink process.


DBCC SHRINKFILE (DB_LOG(Log file Logical name) ,1000(desired Log file size (MB) )

If log file size does not reduce after applying these steps, backup transaction log and try again the command above
Read more...

Active Directory Health Check

Be sure your AD structure is healthy.


You can find Dcdiag , Netdiag , repadmin tools in WINDOWS 2003 support tools

in the command prompt.

md temp

Dcdiag.exe /v >>c:\temp\pre_dcdiag.txt
Netdiag.exe /v >>c:\temp\pre_Netdiag.txt
repadmin /replsum /errorsonly >>c:\temp\pre_repadmin_err.txt

Dcdiag.exe /test:DNS /DNSALL /e /v
Dcdiag.exe /test:DcPromo /e /v
Dcdiag.exe /test:RegisterInDNS
Read more...

Userenv eventID 1030/1058 Error

Solution Offer 1)

1. dfsutil /purgemupcache (you can find dfsutil.exe tools in Windows 2003 Support )
2. Check if the regsitry value above is exist and have correct value.
HKLM\System\CurrentControlSet\Services\Mup\DisableDFS=0
HKLM\Software\Policies\Microsoft\Windows\NetCache\Enabled=1
HKLM\Software\Microsoft\Windows\CurrentVersion\NetCache\Enabled=1
3. Kill mobsync.exe process from task manager.
4. Re-initialize the offline files cache and database
http://support.microsoft.com/kb/230738

5. Restart your server
Kaynak :http://support.microsoft.com/kb/230738

Solution Offer 2)

If you face with 1030 / 1058 error on server that have two NIC card (NIC1:Intranet , NIC2:Internet)

Try these steps below.

Control Panel -- Network Connections - Advanced - Advanced Settings -
In the connections tab be sure that your Intranet NIC card is on the top position.

Solution offer 3)

1. Open Regsitry Editor
2. Find HKLM\System\CurrentControlSet\Control\Lsa subkey
3. Find disabledomaincreds key in the detail pane
4. Modify its value to 1.
5. Restart your server.
Read more...

Thursday, January 29, 2009

"There is insufficient system memory to run this query"

If you get "There is insufficient system memory to run this query" in SQL server 2005 SP2

http://support.microsoft.com/kb/951217/en-us

Try the fix that you can get from above link.
Read more...

Blocking USB flash disks on Windows Vista



Start - Run





gpedit.msc


Computer Configuration - Administrative Templates - System - Removable Storage access

In the right pane you can configure your desired settings.


Read more...

Viewing the SPID and code of query that cause block on SQL server

Viewing the SPID and code of query that cause block on SQL server

SPID :

select distinct blocked from sysprocesses where blocked > 0

Code :

dbcc inputbuffer(Spid)

or

select * from sysprocesses where spid=spid_number
Read more...

Can not generate SSPI Context

"Can not generate SSPI Context"

Try starting SQL services by using local or domain administrator account.
Be sure that your DNS has resolved yor server name correctly
Read more...

"Windows cannot access the specified device, path"

"Windows cannot access the specified device, path,
or file" Error.

If you get this error while you are connect to share on Windows 2003 server from Windows XP Client

http://www.dougknox.com/xp/fileassoc/xp_exe_fix.zip Download the file and install it to client and try again.
Read more...

Remote Computer Local Group Policy access

If group policy does not work , you can connect client local policy remotely.

Start -- Run
gpedit.msc /gpcomputer: computername
Read more...

Sunday, January 11, 2009

Top 10 Features SQL 2005


Read more...
 
span.fullpost {display:none;}