Search results for query: *

Hi all, How can I delete all calendar events? It's because I've messed up with my pocket pc synchronization and many of my calendar events are duplicated, some triple. I have a backup .pst file and want to apply it but i'd like to clear all the mess away first. Any ideas? Thanks ! andy Please...

Hi all, I don't know if this is the right place to ask this question, but it is related to presentation, which in turn is related to powerpoint. I saw some videos in this website: http://www.learnvisualstudio.net/ and when the are making a presentation, the mouse click actions are...

after I have encrypted a stor proc, how can I know the definition of it? I only want to prevent others to know the definition, but sometimes I've to refer to the definition myself, how can I decrypt it if I have totally forgotten the definition? Thanks... Please visit my WebCam...

Can I use cross join in VFP 6? I tried it but the word 'cross' didn't turn blue and I can't get the desired result. Any ideas? thanks very much! Please visit my WebCam!! http://www.hmcheung.com/

I read from book: Windows collation is based on the rules for an associated windows locale. What does this mean? What's the locale of Windows? Thanks! Please visit my WebCam!! http://www.hmcheung.com/

Anyone encountered an error 42000? When I use EM to backup my pubs database to a directory other than the default backup directory, I've got an SQL-DMO error (ODBC SQLState: 42000). It says 'Cannot open backup device 'D:\sql_backup\pubs.bak'. Device error or device off-line. See the SQL Server...

Hi, I have a free table created in foxpro 6.0. I've exported it to a foxpro 2.X format. When I tried to directly open them in excel2000, only the one in 2.X format can be opened. the 6.0 one returns a wrong format error message. Is there any method to directly open a 6.0 format free table in...

Hi, I have thumbnails in one frame, by clicking on the thumbnail, the photo will appear in another frame. Now I want to display a description for the photo in text (not in a text box or text field) at the same time I click on the thumbnail. How can I accomplish this? for the photo I can control...

I have a field that is full-text indexed. This field contains traditional chinese charaters and the collation of this field is set to 'Chinese_Taiwan_Stroke'. But when I query for a chinese word it says: Server: Msg 7619, Level 16, State 1, Line 1 A clause of the query contained only ignored...

I want to do this: update table_1 set col_1='ABC' + rtrim(col_2) but I get this: msg 8152 String or binary data would be truncated. the statement has been terminated. How can I get around this error? Thanks! Please visit my WebCam!! http://i.am/andycheung...

Hi, Is there anything in FoxPro like the VARRAY datatype in Oracle? So that I can put, for example, more than one email address for each record in my employee table. Thanks! Please visit my WebCam!! http://i.am/andycheung

What should I do in QA to obtain a list all the physical location of DBs on my SQL Server? I mean the location for all the .mdf and .ldf files. Thanks! Please visit my WebCam!! http://i.am/andycheung

If I accidentally issue the command truncate table employee and I don't have any backup, is there any ways to undo the truncate? thanks! Please visit my WebCam!! http://i.am/andycheung

I've got SQL Server 2000 installed on a server. Do I need separate license when I install only the client tools on my workstation? Thanks! Please visit my WebCam!! http://i.am/andycheung

I have a DB01 originally residing on c:\Data together with it's log file. But the c: drive is becoming full. I've to move it to d:\Data . How should I do this? thanks! Please visit my WebCam!! http://i.am/andycheung

Is Stor Proc compiled or interpreted? Thanks! Please visit my WebCam!! http://i.am/andycheung

How can I do this: select * from emp order by RANDOM ??? thanks very much! Please visit my WebCam!! http://i.am/andycheung

I want to set a filter in the Profiler. I do not want to the profiler to capture those events that the TextData is empty, how should I set in the filter property 'Not Like'? thanks! Please visit my WebCam!! http://i.am/andycheung

Is there a limit of the maximum number of mails in the sendbox? Can I use programme to generate 10,000 emails in sendbox and send them in one click? thanks! Please visit my WebCam!! http://i.am/andycheung

How should I rename a database in SQL Server? (any version) Please visit my WebCam!! http://i.am/andycheung