What to do if Your Image can't be displayed in Yahoo Messenger

If your image can't be displayed in your YM, some ways worth to try:

1. Re-install your adobe flash player


2. If the first way doesn't work, you still can change your display image by:
• Open C:\Program Files\Yahoo!\Messenger\Profiles\[Your YM Account]\My Icons
• It'll show you all your display images you've inserted to YM in current PC
• Click on run in the start menu of Windows, type regedit:HKEY_CURRENT_USER -> Software -> Yahoo -> pager -> profiles -> [Your YM Account] -> Friend Icon
• Change/modify picture name in the path value to your desired picture name in C:\Program Files\Yahoo!\Messenger\Profiles\[Your YM Account]\My Icons folder
• Re-log in your Yahoo Messenger

You'll find actually it's really very easy to change display image in Yahoo Messenger.

Default Trace in LOG folder of SQL Server 2005: Don’t Bother to Delete Them

When you look into your Microsoft SQL Server files, you’ll find 5 trace files in C:\program Files\Microsot SQL Server\MSSQL.1\MSSQL\LOG (if you install SQL Server in drive C). These trace files are running by the default on your SQL Server.

And if you’ve been thinking of deleting it to free some space in your C drive, don’t bother to do it! Here is the explanation why u don't need to delete it.
There’re only 5 trace files with maximum 20 MB of maximum size each. The number in the trace file name indicates its sequence. If a trace file has reached its maximum size (20 MB), a new trace file will be created. So, even they're deleted, they'll be created again as long as the SQL is still working.

Here’s the query to check the currently running of trace file:
SELECT * FROM ::fn_trace_getinfo(DEFAULT)

Property column has the following meaning: 1 = trace option, 2 = trace file name, 3 = maximum size of trace file, 4 = trace stop time, 5 = current trace status.
Hope this information will be useful for you ...

How to Move MSDB database to another drive

If your MSDB database in drive C and it keeps growing, then one of the solutions is to move it into another disk drive, maybe to D or E. MSDB can’t be detach and attach as we do it in user database. I got this problem when I noticed the free space in my drive C is almost 0 while all my database have been kept in drive D. And then I notice the MSDB database keeps growing every day. So I’ve been searched about the way to move it into drive D too. Fortunately, I got the solutions, and it works perfectly well.
What to do is:

1.Open SQL Server Configuration Manager














2.Stop the SQL Server Service and make sure SQL Server Agent is stopped as well











3.Open the properties of SQL Server, in Advance tab, add parameter -c;-m;-T3608 into the parameter values, and then click OK. That's makes SQL to be openned in single user mode.








4.Restart SQL Server Service and Open SQL Server Management Studio without connect to any server. And then click on New Query and run the query:
use master
go
sp_detach_db ‘msdb’
go

5.Move msdbdata.mdf and msdblog.ldf in drive C (usually in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) to another drive

6.Delete the added parameter and restart service of SQL Server and SQL Server Agent

7.Attach MSDB database using query:
use master
go
sp_attach_db ‘msdb’,’D:\Database Files\msdbdata.mdf’, ’D:\ Database Files \msdblog.ldf’
go

ODBC Drivers error '80040e37' [Microsoft] [ODBC SQL Server Driver][SQL Server]Invalid object name in ASP

When I was trying the asp files in the server, I got this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TableName'.
/web/FileName.asp, line 363

To fix this problem, just need to write query included server name in select query, as example below:
SELECT * FROM servername.dbo.tablename

It really works...

HOW TO EMBEDDED SONG INTO POWER POINT FILE

Here I want to share how to embedded song file into power point file. So, you don't need to send the song file when you send your power point file, because the song is already embedded in it. How to make it works:

1. Use wav file instead of mp3 file, convert song into wav file
2. In the Tools > Option > General, input "Link sound with file size greater than", with value more than your wav song file. Ex: 50000 Kb
3. Save your power point file, notice the size of your power point file
4. Insert song from Insert > Movies and Sounds > Sound from File
5. Browse the wav song
6. Save power point file, then notice again if the file size increase, then you've successfully embedded.

Try it, it really works, good luck...

How to create table of content automatically in your word document

Maybe some people still use bullets and Numbering in arranging table of contents, it needs quite a long time to arrange it. Here are the way to create it easily and quickly, you just need a minute.

1. Identify the text which you want to appear in the Table of Contents: Apply the style by clicking the Style box on the Formatting toolbar and choose Heading style
2. Create the Table of Contents: Insert > Reference > Tables and Indexes. Click on the Table of Contents Tab. Click OK.
3. Customize the Table of Contents (if you need to)