Friday, October 31, 2008
Who is in MSSQL
USE Master
DECLARE @dbid INT
SELECT @dbid = dbid FROM sys.sysdatabases WHERE name = ”
IF EXISTS (SELECT spid FROM sys.sysprocesses WHERE dbid = @dbid)
BEGIN
RAISERROR (’The restore cannot be done’, 16, 1)
SELECT ‘These processes are blocking the restore from occurring’ AS Note, spid, last_batch, status, hostname, loginame FROM sys.sysprocesses WHERE dbid = @dbid
END
Source: http://blog.sqlauthority.com/2007/12/07/sql-server-fix-error-3702-cannot-drop-database-because-it-is-currently-in-use/
Friday, October 17, 2008
Quick way to verify SMTP server
Source From: http://www.garnetchaney.com/how_to_telnet_to_a_mail_server.shtml
SMTP - To Send Mail
To send mail:- Bring up telnet
- Type "open (your mail server here) 25"
- This will connect to your mail server on port 25 (the smtp port) SMTP stands for Simple Mail Transfer Protocol.
- Type "HELO (site you want the mail server to record you connecting from...this can be anything you want)" Some mail servers do not require this line.
- If you want the mail server/receiver of the email to know who this email is from type "MAIL FROM: yourname@whereever.com (replace this with whatever you want)" **Note: Some mail servers require this line...if you get an error that blank sender is not allowed than use this command.
- To tell the mail server where you want your mail to go to type "RCPT TO: (where you want the mail to go)". **Warning: If you incorrectly enter the destination of the mail it will be sent to the postmaster of the receiving server (usually the mail server will give you an error informing you that the user does not exist and that this message will be sent to the postmaster).
- Then type "DATA"
- The mail server will give you specific instructions on how to terminate the message (usually a "." on a line by itself) you must use this or else you will not be able to send the message!
- Type your message
- Then terminate the message with the appropriate character
- At this point you generally type "QUIT" to disconnect as your message is sent.
Wednesday, October 8, 2008
There is always a good time to buy stock
There is always a best time to buy stock. This is nothing more true than now. Dow Jones closed overnight lossing 500 over points and for the past week already lost about 1400 pts. It's below 10000.
I am to share my portfolio of stocks that I would love to invest provided with spare cash :) wish...
I am sure I can manage a return of at least 10% for the next 2 years.
Source: Marketwatch.com for the portfolio management.
Number of stocks are solely my preference. Everyone should have their own. Just like individual preference for colours/cars/food etc....
Subscribe to:
Posts (Atom)