About Experts Sitemap - Group 37 - Page 16 2015-04-21

Mozilla Firefox: Firefox, flash player 10, speed internet connection
flash player 10, speed internet connection, shockwave player: hi thanks for your question. make sure you have shockwave player and flash player 10 installed for firefox. then try this: 1.Type “about:config” into the address bar and hit enter. Scroll down and look for the following entries: network.http.pipelining...

Mozilla Firefox: firefox not working, hidden processes, ccleaner
hidden processes, ccleaner, internet explorer: hi thanks for your question. firstly restart your pc this should clear any hidden processes that firefox maybe using in .dll files. try to reinstall it after that. if that doesnt work after restarting pc do a drive cleaner with ccleaner to remove...

Mozilla Firefox: addon, ok experience, hi thanks
ok experience, hi thanks, anti virus: hi thanks for your question. firstly webpages dont appear at times and this is due to an unknown problem. mostly likely cause is cookies/java or add-ons blocked. 99% of add-ons on the offical website are free. firefox alone makes browsing far more...

Mozilla Firefox: Firefox Tool Bar, mail button, hi thanks
mail button, hi thanks, toolbar buttons: hi thanks for your question right click on the same bar your home page, back, forward icons are on, scroll down to customize command bar, scroll across to add or remove commands... select it, highlight read mail and add it to current toolbar buttons. ...

Mozilla Firefox: mouse disappears
Mozilla Firefox: mouse disappears

Mozilla Firefox: iTunes mystery, vocal element, library thanks
vocal element, library thanks, music folder: hi thanks for your question. yes when you reinstall itunes you lose songs from the library. but these are files that should not have been deleted. your song files should be located in your itunes music folder where you just need to re-add them to...

Mozilla Firefox: Mozilla Firefox Download Problems, shockwave player, question thanks
shockwave player, question thanks, beta version: its the last update of version 2 you have to go to filehippo.com and download latest 3.0.4 for version 3. to uncheck open browser select tools options then its in the content tab, privacy tab and security tab read through the options and you want to enable...

Mozilla Firefox: mouse disappears, hi thanks, firefox
hi thanks, firefox, fraction: hi thanks for your question firstly make sure you have update 3.0.4 secondly if you have logitek mouse there have been reports of bugs with firefox, no cure at moment. third allow firefox to fully open before touching mouse. fourth open a 2nd...

Mozilla Firefox: no response, shockwave player, java flash
shockwave player, java flash, hi thanks: hi thanks for your question. download latest java, flash player and shockwave player as some websites require these programs/plug-ins. if no good reinstall firefox or if still no good try using internet explorer as firefox do have purchasing problems...

Mozilla Firefox: sending movies attached to emails, canon digital camera, winzip 7
canon digital camera, winzip 7, canon digital: hi thanks for your question. you are in the wrong category but i can help you. you need to compress the file in either a .zip file or .rar file using a program such as winzip. 7-zip is freeware and does exactly the same. this will reduce size but still...

Mozilla Firefox: some things blank after update, ancestry com, shockwave player
ancestry com, shockwave player, internal windows: hi thanks for your question. firstly go on filehippo.com and make sure you do have the up to date version which should be 3.0.4. secondly these problems are common in firefox due to the privacy and security settings howver there is no simple fix. allow...

Mozilla Firefox: Disabling saving of form data, configuration window, private data
configuration window, private data, web forms: Hi Philip, Of course, there s a way to avoid that easily. But first let me show you how to delete the data that Firefox has saved about your forms: In the Tools menu, you will find an option called Clear private data , click on it. There you must...

Mozilla Firefox: Error Displaying web pages!!, three boxes, connection settings
three boxes, connection settings, temporary solution: Hi Karn, Apologies for the late reply. I don t really know what to suggest to fix that, since I never had this problem or known somebody whose firefox was doing that. The only thing I can think of is trying to uninstall your current firefox and installing...

Mozilla Firefox: MozillaFirefox e mail, email service provider, mozillafirefox
email service provider, mozillafirefox, web front: Hi Samuel, I would need to know what s the name or web page of your email service provider to answer your question. I m sorry it s not that generic that I can answer it now. For your information, it depends if your email service provider has a web front-end...

Mozilla Firefox: Backpage and Forward Arrows On Browser Are Missing, forward arrows, arrow buttons
forward arrows, arrow buttons, forward buttons: Hi Frank, I m glad that you found the back/forward buttons ! Anyway, from what you describe, the problem occurs when using Firefox, but it has something to do with the system. Let s try something: disable every single add-on that you ve installed on...

Mozilla Firefox: Firefox loading problem, virus scans, loading problem
virus scans, loading problem, apologies: Hi Terilyn, Apologies for the late reply. A file can be corrupted for a lot of reasons, probably being an interrupted download the most common. I guess you ve tried to download Firefox from the Official website: http://www.mozilla.com/en-US/firefox/...

Mozilla Firefox: page issues, open source software, uncommon situation
open source software, uncommon situation, text boxes: Hi Scott, It s not an uncommon situation, since Frontpage doesn t make fully-compatible pages. They look good on IE because both software are from Microsoft, but Firefox needs pages that follow the standards of the XHTML. Furthermore, it s likely that...

Mozilla Firefox: SIDEBAR, dear frank, e mail
dear frank, e mail: Dear Frank, That s easy, you just have to click on the View menu, and then where is says Sidebar . Whenever a sidebar is active, a check mark will appear next to its name here. Thus, you just have to uncheck all options here and the sidebar will disappear....

Mozilla Firefox: Server not found, annoying problem, domain example
annoying problem, domain example, valid address: Hi Long, I ve checked the address forums.example.com and it doesn t exist, since the domain example.com is a reserved address which cannot host any web. Anyway, the error you re shown happens because http://forumdisplay.php it s not a valid address. ...

Mozilla Firefox: Mozilla Firefox email, mozilla thunderbird, mozilla firefox
mozilla thunderbird, mozilla firefox, mail clients: hi. mozilla firefox is the browser. if you have the email server you mean you have mozilla thunderbird which is mozilla s e-mail side and a different program. i am not familiar with mozilla thunderbird. I just checked it it and its the same as outlook...

Mozilla Firefox: Website not loading, flashblock, videos images
flashblock, videos images, internet explorer: hi thanks for your question. firefox is a more secure browser there maybe a reason such as your security settings block your website such as flashblock or ad block etc etc if you use those extensions. i have checked out your website on firefox and i...

Mozilla Firefox: Firefox 3, forward arrows, firfox
forward arrows, firfox, google: i had someone with the exact same problem as you and they had norton, was just seeing if there was a connection. even though norton expired if it is still on your machine then some conficts may still happen or the trial version may still be in use. i dont...

Mozilla Firefox: Firefox Takes Over as Default Browser, default internet explorer, secondary browser
default internet explorer, secondary browser, dominant browser: sorry for the misunderstanding. i now think it could be a bit of history or registry that stays when you uninstall firefox. stick with v2 for now, it could be a problem with firefox 3 itself being a stand-alone dominant browser with many programs. ...

Mozilla Firefox: Firefox Takes Over as Default Browser, default browser, arrows
Mozilla Firefox: Firefox Takes Over as Default Browser, default browser, arrows, browser windows

Mozilla Firefox: firefox portable pls help, portable firefox, fire fox
portable firefox, fire fox, web sights: firefox 3.0.2 has been released today therefore portable will be soon. see if that will work and it will keep your notes etc. to enable history click tools options privacy tab then see if all boxes are selected concerning history and cookies. ...

Mozilla Firefox: Menu not working right, shockwave player, clicking tools
shockwave player, clicking tools, pop ups: hi thanks for your question. firstly never remove default plug-ins that come with firefox it will cause the whole browser to become unstable. it could be a firefox bug. version 3.0.2 was out today try the upgrade they may have fixed it. If not, then...

Mozilla Firefox: setting up firefox screen, mail box, select tools
mail box, select tools, firefox browser: hello thanks for your question. in the firefox browser at top select tools which is 5th tab along. scroll down to options. on the main section you will see home page. what you need to do is sign in to your e-mail then copy and paste the web link to the...

Mozilla Firefox: Firefox running, ken ken, internet explorer
ken ken, internet explorer, limewire: Ken - Sorry to hear that you are still having problems with Firefox. Are you using a PC or a Mac? Here is an article by Firefox about possible reasons why you may be getting these errors. Please read through them and let me know if you think any of...

Mozilla Firefox: favorites, internet explorer 3, brousers
internet explorer 3, brousers, import html: Hi Chuck - Try this: 1) Open Firefox 2) From the Bookmarks menu choose Organize Bookmarks 3) A menu will open, on the top right of this menu there is a button that looks like a star. Click on this button, it will open a menu. 4) From that menu,...

Mozilla Firefox: Installing Firefox, susan cline, internet service provider
susan cline, internet service provider, internet explorer: Before I answer this question I think it s important to know why Internet Explorer is not working. If it s not opening because the application is corrupted or the program simple won t launch then Firefox will be a good alternative. However, if it s not working...

Mozilla Firefox: Firefox, mozilla firefox, hard time
mozilla firefox, hard time: Hello David - Thanks for your question. I am having a hard time understanding what you mean by the word site . Are you talking about a specific website? If so, what is the website? Or, are you talking about a computer or account on your computer? ...

Mozilla Firefox: Firefox tool bars, computer hope, mozilla firefox
computer hope, mozilla firefox, news games: ZZ - With Firefox open click on the View menu at the top. Then select Toolbars . Remove the checkmark by the toolbars you do not wish to see. To permanently remove the toolbars you need to delete or uninstall the application from your computer....

Mozilla Firefox: firefox 2 or 3, mouse speed settings, verbal translation
mouse speed settings, verbal translation, bonus question: Hi Nick - Question 1: I m not a Windows XP expert but have you tried changing your mouse speed settings in the Control Panel. Perhaps the mouse has been set to be at the slowest speed. Here is an article that shows you how to change the settings:http://www.microsoft.com/windowsxp/using/setup/personalize/mouse.mspx...

Mozilla Firefox: Altavista and Google, yahoo search page, overture services inc
yahoo search page, overture services inc, convinence: Dear Dallas, There s no such an issue with FireFox. You can customize Google Advanced Search (For Ex: number of results, etc). Please recheck the same result criteria in both 2 browsers for your convinence (IE & FireFox). Yes, Yahoo has acquired AltaVista...

Mozilla Firefox: blank screens, incompatibility issue, yahoo email account
incompatibility issue, yahoo email account, windows task manager: Dear Patty, Actually there s no such incompatibility issue with Windows 7 & Flash Plugin. When you are getting blank screens/ firefox freezes , try running windows task manager. Under processes tab check how much of memory used by firfox. It s better if...

Mozilla Firefox: Confirm message, ebay, john dear
ebay, john dear, anjana: Dear John, I think this must be a virus or some intruding script running in your browser. If you are using FireFox, try disabling all your pluggings for a moment & re visit those websites (ebay & others). To disable pluggins temporarily, in FireFox ...

Mozilla Firefox: Flash videos not working, security programs, internet speed
security programs, internet speed, additional security: Dear Sajjan, What s you Flash Player version? If it s not the latest one , try downloading & installing the latest player. If you have 5mb broadband connection, your videos must start playing in flash asap you hit play button. Have you installed any...

Mozilla Firefox: Altavista and Google, google advanced search, google problem
Mozilla Firefox: Altavista and Google, google advanced search, google problem, experts answer

Mozilla Firefox: Plugin-Container.exe Using All My CPU, Firefox plugin container, increase performance in firefox
Firefox plugin container, increase performance in firefox: Dear Amanda, Plugin container is the application which handles plugins in FireFox. It tends to grab more resources if there are lot of plugins to handle. So what you can do is just disable unnecessary/unwanted Plugins/Extensions from your browser. Just...

Mozilla Firefox: Thunderbird, thunderbird.exe has encountered a problem and needs to close by anjana silva
thunderbird.exe has encountered a problem and needs to close by anjana silva: Dear Ken, I think this is a problem with your Thunderbird Profile. Try doing like this. Start - Run - in the box type, thunderbird.exe -p (without quotations) and click OK. It ll open your profile manager. Create a new profile and uncheck Don t...

Mozilla Firefox: Missing Tabs, website tabs missing after updating firefox
website tabs missing after updating firefox: Dear Theresa, This might be, your bank website/page uses some outdated css/javascripts which is not compatible with the latest firefox. But I recommend you to ask this issue directly from Mozilla. Here s the link: http://support.mozilla.com/en-US/kb/Ask+a+question...

Mozilla Firefox: wireless, Anjana Silva
Anjana Silva: Dear Eddie, There s no limitation that you must access your network settings using firefox. You can access your router using any web browser. Accessing routers may change vendor to vendor. The common way of accessing a router is typing 192.168.1.1 in...

Mozilla Firefox: Why Do Firefox and PlugIn Container Do Nothing But Rev Up CPUs Now?, firefox increase performance, reduce memory usage by anjana silva
firefox increase performance, reduce memory usage by anjana silva: Hi Amanda, Extremely sorry for the delay, as I was busy. Back to your question, FireFox has the capability of using add-ons/pluggins to enhance it s features. But, meantime it ll decrease the browsers performance because it hunts your CPU Speed, RAM,...

Mozilla Firefox: Mozilla Thunderbird, Mozilla Thunderbird 1.5 inbox size too large
Mozilla Thunderbird 1.5 inbox size too large: Dear Charles Smith, You could have posted this question in my Mozilla Thunderbird page. Anyway, let me give you some solutions. I can say that there s is a minimum chance of having a very large hidden file unless there s a virus in your system. Also...

Mozilla Firefox: Password, Firefox login change
Firefox login change: Hi Steve, You can do it easily. Please follow the steps below. (1). Open Mozilla FireFox & Go to Tools-- Options. (2). In the popping window, click the Security Tab. (3). Click the Saved Passwords under Security Tab. (4). Now a window will...

Mozilla Firefox: browser login keeper, cookies, keep logging on
cookies, keep logging on: Dear Gary, I think you can easily do with a cookies enabled browser. Since all browsers supports cookies, you may just need to enable cookies. When you are logging to a site tick the Remember Me option. When you finished your work (Ex: checking your mail)...

Mozilla Firefox: Color of visited web links, firefox history
firefox history : Dear Gib, I just got your question correctly. This is not a problem of link colors. Visited links are automatically saved by browser history. I think your history has not been enabled. To enable go to Tools - Options - Privacy (tab) - In history pane...

Mozilla Firefox: Color of visited web links, content tab, colors
Mozilla Firefox: Color of visited web links, content tab, colors

Mozilla Firefox: Upgrade, firefox update
firefox update: Dear Wayne, You can upgrade your existing FireFox with the latest version without loosing anything. Just go to Help - Check for Updates. If there are any new versions, it ll ask you to update. Click update whenever it appears. Don t worry you ll not...

Mozilla Firefox: CCange a password that Firefox remembers, firefox changing username password
firefox changing username password: Dear Steven, To replace your old password you have to delete the existing username/password from the FireFox memory & re-enter. To delete. Go to Tools - Options - Security (Tab) - Saved Password. In that small popping window you can select your login...

Mozilla Firefox: Firefox cannot find the server @, Firefox cache
Firefox cache: Dear Gord, I think page loads from your cache memory. Just refreshing is not enough. Press Ctrl + F5 for a hard refresh. Then you ll get connected to the page. This happens when your surf a web page & after surfing browser doesn t clear the cache memory...

Mozilla Firefox: Slow internet, computer speed vs firefox
computer speed vs firefox: Dear Tim, Good Morning to you! Q: Does memory space improve internet speed with firefox? A : Basically no. But increasing the memory (RAM & Hard Disk Space), will increase the performance of your computer theoretically. It ll affect to your programs...

Mozilla Firefox: Computer memory, playing internet games, micorsoft word
playing internet games, micorsoft word, memory space: Dear Marla, Q: Does playing these internet games use up memory space. A: When playing internet games (sometimes) informataion will be temporarly downloaded to your PC. But after you finished gaming & close the browser it will automatically remove those...

Mozilla Firefox: Enable Third Party Cookies, enable firefox third party cookies
enable firefox third party cookies: Dear John, You can set your FireFox Browser to accept third-party cookies. Please follow the steps below. For the latest firefox (3.6 or later) Tools - Options - Under Privacy Tab - Under the drop down menu select use custom settings for history...

Mozilla Firefox: Thunderbird Question, mozilla thunderbird restore issue
mozilla thunderbird restore issue: Dear Owen, I got a little doubt to solve, Once you say that you lost your recently received mails, and again saing your older mails are gone. Can you plese sepcify this issue. So I may come up with a proper answer. Also please mention your steps, how...

Mozilla Firefox: download, mirror download
mirror download: Dear Gavin, If the mirror is listed in Firefox website, feel free to download it. I think you have not get the point of what is a mirror. I kindly request you to visit the Wikipedia link below, http://en.wikipedia.org/wiki/Mirror_%28computing%29 ...

Mozilla Firefox: Firefox and Facebook, facebook vs firefox
facebook vs firefox: Dear Mike, I think this is because of the version of your firefox browser. Try updating your firefox to the latest version. The latest version is 3.6.9. You can download & install it easily (http://www.mozilla.com/en-US/firefox/personal.html). Facebook...

Mozilla Firefox: freezing, firefox freezing
firefox freezing: Dear Bernie, FireFox does freeze when your system is not up to the performance level or your Operating System is loaded with huge amount of unwanted application. If your FireFox have huge number of add-on s then also it tends to freeze. The best option...

Mozilla Firefox: Plugin not working, windows media player 11 plugin for firefox
windows media player 11 plugin for firefox: Dear Pacman, Please refer to this firefox page for further instructions. http://support.mozilla.com/en-US/kb/Using+the+Windows+Media+Player+plugin+with+Firefox If it doesn t help you, try downloading windows media player 11 plug-in directly via Microsoft...

Mozilla Firefox: Problem Google Maps, Google maps slider missing
Google maps slider missing: Dear Brian, Have you dropped that yellow color man like item to the map? If so, there s a cross button in the top-right corner of the map area. Click it to return to the previous screen which you ll find the slider again. If this doesn t work try removing...

Mozilla Firefox: Pop Ups in Firefox, pop ups, atrl
pop ups, atrl, chat pop: Dear Dave, Sorry for the delay as I was sick. Did you ticked the popup blocker in Tools - Options - Content (tab)? Also there s an option that u can add exceptions so certain popups will be still allowed. Tell me if you haven t resolved. Cheers!...

Mozilla Firefox: default search engine, change default search engine in firefox by Anjana Silva
change default search engine in firefox by Anjana Silva: Dear Rickson, Type about:config in the browser, without quotation. Click on the proceed button. In the filter paste this browser.search.defaultenginename (without quotation) and hit enter. Now you ll see a single line, just right click in there and...

Mozilla Firefox: Not able to access websites listed under history, history question, windows key
history question, windows key, userprofile: I suggest uninstalling Mozilla Firefox again, then press the Windows key and R and enter the following, if using Windows 7 or Windows Vista: %userprofile%AppDataRoamingMozilla A folder called Mozilla will come up and you need to delete everything...

Mozilla Firefox: Inprivate Browsing, private browsing, anjana
private browsing, anjana, internet explorer: Dear Dave, When you are in Private browsing in Firefox, it does not save history, cache, cookies in your browser. So you won t be able to visit these sites later. To overcome this you have to bookmark a site when you are in private browsing. Cheers!...

Mozilla Firefox: Firefox History, internet explorer 8, web cheers
internet explorer 8, web cheers, dear dave: Dear Dave, Actually there s no need to access word documents, spreadsheets through a web browser. When you try to access a document file (which is in your pc) through a web browser, it asks you to open or download. The browser does not save the content...

Mozilla Firefox: mozilla firefox, anjana silva
anjana silva: Dear Theresa, First I need to point that installing updates is same as the re-installing a new version. Updating does not take much time but re-installing a latest software may take more time because of the large file size. Anyhow as I read your problem...

Mozilla Firefox: Downloads, modzilla, video song
modzilla, video song, cheers: Hello, Can you be little more specific? Can t download means, is that files?, videos?, songs? What happened when you click on a download button next to a file, video, song? Please send me the link which you tried to download. Cheers! Anjan...

Mozilla Firefox: Downloads
Mozilla Firefox: Downloads

Mozilla Firefox: mozilla firefox, anjana silva
anjana silva: Dear Theresa, First I need to point that installing updates is same as the re-installing a new version. Updating does not take much time but re-installing a latest software may take more time because of the large file size. Anyhow as I read your problem...

Mozilla Firefox: stop videos playing, new tabs, many thanks
new tabs, many thanks, cheers: Dear Jeff, There are many ways you can do this. To do this you have to install an add-on to your browser. Please check the link below, https://addons.mozilla.org/en-US/firefox/addon/stop-autoplay/ There are some more methods freely available : http://www.howtogeek.com/howto/internet/firefox/stop-youtube-videos-from-automatically-playing-in-firefox/...

Mozilla Firefox: Google News page in Spanish, english thanks, google
english thanks, google, news link: This is a great question. After a few web-searches I have found that this is a very common problem, and I believe I have found a solution. Go to: http://news.google.com/news Once you are at: http://news.google.com/news, study the below pictures and...

Mozilla Firefox: error message when opening Firefox, sandbags, tool bars
sandbags, tool bars, sandbag: To make it simple, most people love Firefox except for this issue... This happens to me all the time and I have yet to find a solution. What could be causing this is that Firefox may be closed on the screen but due to the extensions and add-ons it...

Mozilla Firefox: IncrediBar Removal, word programs, mozilla firefox
word programs, mozilla firefox, mozilla explorer: Hello Malcolm, I first would like to thank you for taking the time to ask your question. I sure hope I can help you, and if you have any further questions on this issue please feel free to ask a follow-up question. You should be able to remove the toolbar...

Mozilla Firefox: flash player
Hi Richard, There is a huge scam running these days asking you to update your flash player. Don t click on those links/adverts. What you can simply do is to check whether your Flash player is latest or not, visit following link, which is from Adobe and...

Mozilla Firefox: Firefox crashing
Mozilla Firefox: Firefox crashing

Mozilla Firefox: Firefox crashing, Anjana Silva FireFox freezing solutions
Anjana Silva FireFox freezing solutions: Hi Don, Seems like you have so much FF plugins/extension installed. Try reducing/removing any unwanted plugins/extensions from your FF and check it again. Perhaps your update to FF cause FF to freeze with incompatible addons. Here are some useful resources...

Mozilla Firefox: Firefox as second browser?, Anjana Silva Alternative for IE
Anjana Silva Alternative for IE: Hello Dick, I am quite surprised you used IE for a quite long time without any issue. Most of the time,(for me) IE tends to slow down the PC after some time. So I only use IE to download FF (FireFox) and Chrome. I suggest you to download Chrome, instead...

Mozilla Firefox: mozilla browser opening problem, Anjana Silva FireFox slowing down solutions
Anjana Silva FireFox slowing down solutions: Hello Silveter, I think latest update has slowed down your FF. Perhaps because of incompatible third party extensions/plugins/etc. Try removing any unwanted plugins/extensions/ clear your cache, cookies, search history, permanently(be aware, this will...

Mozilla Firefox: changing home screen, Anjana Silva FireFox plugins/extensions problems
Anjana Silva FireFox plugins/extensions problems: Hi Jer, Thank you for seeking my help on this. Did you try disabling extensions/plugins in your FF browser one by one? One thing you can do is, disable extensions/plugins you think which cause this problem in the FF and check whether the problem still...

Mozilla Firefox: Is there an add-on for this?
Hi TJ, Sorry I didn t get to you sooner. Your question was posted privately. I ve enabled it to be public so others can benefit. In future questions, please do not mark as private. To answer your question, yes there is an addon for this. The one I use...

Mozilla Firefox: Server Connection Failed
Hi Barbara, Thanks for letting me know. I went to the site again, and it is indeed working. .gov sites have been down for me several times with the EXACT same message so next time it happens, just wait it out. Also, it would be best to put the Use the...

Mozilla Firefox: Firefox unresponsive
Hi Danny, I m very sorry for the delay in answering! Hopefully you have not given up on Firefox. I ve recently have some issues in my personal life but I m ready to answer. Can you try to start Firefox in Safe Mode and see if it works fine? Usually slowness...

Mozilla Firefox: Browzer; tabs on opening subjects
Hi Art, Sorry for the long delay. Family issues. Now let s see what s going on with Firefox. Can you elaborate more on what you are seeing or can you attach a screenshot? If you do not know how to attach a screenshot or create one, please follow the...

Mozilla Firefox: Right Click Context Menu
Hi Mike, Thank you for patiently waiting. I ve been having some family troubles and I am just catching up. A few things to try. 1. Go to about:config via the Address Bar 2. Press the button saying you ll be careful. 3. Search for browser,search...

Mozilla Firefox: Uninvited Incoming file for download
Hi Bill, Sorry about the delay. I keep forgetting to put myself on vacation sometimes. A grey rectangle? Hm. I m guessing that it s something malicious. Firefox doesn t usually do that. You might want to scan your computer with all of these tools. Please...

Mozilla Firefox: bookmarks lost from firefox
Hi Sondra, If you have the JSON file, then you should be able to restore your bookmarks. If that s the old one, you can still recover your bookmarks if you have the original profile folder backed up. Firefox stores everything in its profile folder which...

Mozilla Firefox: how to cc and bcc
Hi Chris. Firefox is strictly a web browser. It s not used for e-mailing. Seeing the CC/BCC fields vary from site to site. You will have to use a web based e-mail provider such as Gmail or Hotmail if you want to CC or BCC or use an e-mail client such as...

Mozilla Firefox: firefox crashing all the time
Hi Kay, I m sorry to hear about Firefox crashing. Re-installing Firefox will not fix the issue as the issue lies within your current configuration of Firefox. This will require a couple of steps to fix. We may have to go back and forth with messages but...

Mozilla Firefox: Filters
This is always a battle for parents to solve. First thing you can do is go to settings, then history. There if you see suspicious websites you can block them from popping up when your kids are on the computer. Also below is a list of filters you can install...

Mozilla Firefox: Filters
This is always a battle for parents to solve. First thing you can do is go to settings, then history. There if you see suspicious websites you can block them from popping up when your kids are on the computer. Also below is a list of filters you can install...

Mozilla Firefox: Firefox Message
Hi Mar. It looks like Firefox is trying to get a file from your ReminderFox extension. This is a problem with the extension itself and not related to Firefox. The only thing you can do is to contact the developer and ask him/her to update their extension....

Mozilla Firefox: Firefox Updating Issue
It s possible that another running program or a previous instance of Firefox that did not close properly is interfering with the Firefox update process. This error can also occur if you share your computer with other users, and another user s account is still...

Mozilla Firefox: add on question, menu works, firefox
menu works, firefox, yoga: Hi Vyasa, I m using Firefox and your top menu works properly here. I think the problem is that you have an older version of Firefox. You can consider upgrading to 2.0 from here: http://www.mozilla.com/en-US/firefox/all.html Let me know if the problem...

Mozilla Firefox: Bookmarks gone, profile gone, hidden folders, tab view
hidden folders, tab view, menu tab: Hi Asia, Hmm well, I think we can still try something. These instructions are valid for Windows2000/XP (tell me if you re using another version). Open the Windows browser (My Computer Local disk) and follow the following path (it has to be exact or...

Mozilla Firefox: Browser crashing, anu garg, gig hd
anu garg, gig hd, pentium iv processor: Hi Zane, In Mozilla, go to Edit, Prefrences, click the + sign next to Advanced, click on Scripts & plug-ins, on the right side of the screen uncheck Navigator under Enable JavaScript For, click OK. That should be the same as in Navigator. It could...

Mozilla Firefox: Changing Home Page on Firefox, home page thanks, internet browser
home page thanks, internet browser, firefox: Hi Alan, Only explanation for this behavior is that Firefox installation is corrupted. No installation choice can bring about this behavior.Uninstall firefox completely, reboot your machine and install it again. Sorry for not having a simpler solution....

Mozilla Firefox: Converting from Netscape, open navigator, netscape navigator
open navigator, netscape navigator, suitable name: Hi Sarah, To import all your bookmarks from Netscape navigator you have to import your book marks from Navigator and import them into Firefox. Exporting bookmarks from Navigator: 1. Open Navigator 2. Goto Bookmarks Manage Bookmarks 3. In the ensuing...

Mozilla Firefox: comcast mosilla firefox internet security, mosilla firefox, conflict with your internet security software
mosilla firefox, conflict with your internet security software, comcast support: Hello Dave, I have never heard of this problem. It isnt a problem with your internet security if you dont have a firewall. The most i can suggest is to disable the pop-up blocker on firefox. If that doesnt work, The only option you have really is to grind...

Mozilla Firefox: cookies, hi john, tools internet
hi john, tools internet, checkbox: Hi John, This is a quite easy question: === Firefox === Open the Options dialog under the Tools menu, select the Privacy tab and you will see the cookies configuration. If you want to deny all cookies except for a concrete server, deactivate the checkbox...

Mozilla Firefox: customizing firefox home page, question pool, google
question pool, google, marlene: Hello Marlene, Your question was sent to the question pool because the expert you chose was unable to answer. I have taken the responsibility of answering. Anyway, i have long since moved my homepage from the firefox homepage, however if you will provide...

Mozilla Firefox: Download Problems, google tool bar, mail location
google tool bar, mail location, mail carrier: Hello Bob, I have had this happen to me before. For some reason the upgrades for Firefox dont always work correctly. What you have to do is uninstall firefox, then go into Program Files and completely delete the folder labeled Mozilla Firefox. Now reinstall...

Mozilla Firefox: Downloads that start up on opening Mozilla, mozilla browser, private data
mozilla browser, private data, temporary files: Hi Mac, Well, it s hard to guess what s going on, but I ll suggest a pair of ideas, so you can check them. Could it be that your homepage has changed? Check it on the Options dialog from the Tools menu, in the Main tab. Another possibility could...

Mozilla Firefox: disable history delete, history days, history folder
history days, history folder, history files: Hi Kevin, I m afraid the answer to your question is: No. Anyway, there are certain things you can do to keep big records of browsed content. From Firefox: increasing the number of days that Firefox keeps history files. Check it from the Tools menu,...

Mozilla Firefox: dreamweaver, amp nbsp, option code
amp nbsp, option code, graphical interface: Hi Beth, That you ask me is quite usual these days as every browser has its own way to understand the HTML code. You can try this: Once in Dreamweaver, edit your webpage (or one of them) as HTML code instead of graphical interface. You can change...

Mozilla Firefox: get e-mail in mozilla firefox, email client, thunderbird
email client, thunderbird, firefox: Hello, I believe they took that feature out of firefox after the last update. Your best option would be to use thunderbird (also by mozilla) to get your email. But as far as starting your email from firefox, you cannot access your email client from firefox...

Mozilla Firefox: email, server mail, mail server
server mail, mail server, secondary address: Hi Victoria, All right, calm down. 2 weeks is too much time for a service not working, but I ve found something that I think it can help you. Please open the following link with your browser: https://update.charter.com/ And you will find a box...

Mozilla Firefox: email, cursor
cursor: Hi David, The easiest way to send a web site to someone is to right click the URL in the Address bar, click Copy. In the email message part, right click the cursor and choose Paste. Another way would be to go to File, Send Link. Hope this helps! ...

Mozilla Firefox: FF error, mail program, firefox browser
mail program, firefox browser, security holes: Hi Mike, Mozilla Patches Mozilla has upgraded its Firefox browser and Thunderbird e-mail program to version 1.5.0.4 to close security holes, some of which could enable an attacker to take control of your PC. So be sure to say yes when either application...

Mozilla Firefox: Firefox, system defaults, click tools
system defaults, click tools, click options: Hello Diana, Most likely you just need to set Firefox as your default browser. To do this, click tools on the menu bar, click options, go the tab that says MAIN at the top, and check where it says system defaults. Make sure that box is checked, the next...

Mozilla Firefox: Firefox 2.0.0.7, zoom, mozilla
zoom, mozilla, web pages: Hi Rob, In Firefox you don t need any Add-on to zoom in and zoom out web pages, since you can do it pressing Ctrl+[mouse scroll up/down] or also by pressing Ctrl+[+ button]/Ctrl+[- button]. This makes text bigger or smaller, and the same is placed under...

Mozilla Firefox: Firefox 2.0, bottom status bar, virus check
bottom status bar, virus check, internet explorer: Hi George, It s hard to guess what s wrong with your Firefox... I ll give you a few tips so you can work on it a bit more: - have you tried several addresses? Sometimes a site might be troublesome with some browsers - are you sure that your internet...

Mozilla Firefox: Firefox, task manager, ross
task manager, ross, profiles: Hi Ross, I get that sometimes too. When that happens, press ctrl+alt+delete to bring up the task manager. At the task manager, go to the processes tab and find the firefox.exe process and end that process. That should fix the problem, unfortunately you...

Mozilla Firefox: Firefox, default browser, internet explorer
default browser, internet explorer, firefox: Hi Greg, The answer is Yes. You can indeed have both browsers in the same computer. In fact, Internet Explorer is a part of the system you can t remove. Say you install Firefox and start using it. It will probably ask you whether you want to use it...

Mozilla Firefox: Firefox not allowing or opening links on webpage, mouse pointer, donna baker
mouse pointer, donna baker, barbara morrison: Hi Dave, I really don t know why can t you see those links. I work at home with a Firefox 2.0.0.6 (just like you) and I can see and click all three links: - over the name of Donna Baker (http://www.4salebydonna.com/) - over the italic paragraph under...

Mozilla Firefox: Firefox and home page, software update, uncheck
software update, uncheck, comcast: Hi Joan, With Firefox opened, go to: http://www.comcast.net/home.html Now go to Tools, options, click General on the left side and on the right side of the screen click Use Current Page under Homepage, click OK. To stop Firefox looking from looking...

Mozilla Firefox: Firefox Not Loading Pages, menu tab, connecting to the internet
menu tab, connecting to the internet, network settings: Hi Larry, From the information you give me, it seems to me that the cause is in your security software. I have an up-to-date Firefox and there are no problems with it connecting to the Internet. What I think it can be due to: 1. When you update,...

Mozilla Firefox: Firefox set as default; but IE always loads, outlook application, default browser
outlook application, default browser, microsoft outlook: Hello again Diana, I took a look at Outlook and it doesnt appear that there is an option to change which browser opens clicked links. Microsoft has a tendency to do this. I apologize for the inconvenience, but at this point you have 2 options. You can either...

Mozilla Firefox: Firefox tabs, window parameter, question thanks
window parameter, question thanks, middle button: Hi Jaco, You re welcome. I m glad that your Firefox worked fine again... maybe it got stressed for a while, and then back to normal. I don t know. It s an X File :P Regarding your second question (don t worry, you can use the same post for more than...

Mozilla Firefox: Firefox, internet browsers, hogs
internet browsers, hogs, shtml: Hi Florence, For some reason, this version of Firefox hogs a lot of memory. Try not having any other programs when running Firefox and see what happens. By any chance, did you download Firefox 1.5 BETA? If yes, I would suggest removing that and install...

Mozilla Firefox: firfox contact, help page, cheers
Mozilla Firefox: firfox contact, help page, cheers, mozilla

Mozilla Firefox: gray area below status bar, chrome directory, gray space
Mozilla Firefox: gray area below status bar, chrome directory, gray space

Mozilla Firefox: Linking from Outlook to FireFox, firefox extension, outlook message
Mozilla Firefox: Linking from Outlook to FireFox, firefox extension, outlook message, ietab

Mozilla Firefox: Menuitem bar appearing suddenly, folder c, firefox extensions
Mozilla Firefox: Menuitem bar appearing suddenly, folder c, firefox extensions, menuitem

Mozilla Firefox: problem loading page, internet explorer
Mozilla Firefox: problem loading page, internet explorer

Mozilla Firefox: Tabs in Firefox, mozilla firefox, tab button
Mozilla Firefox: Tabs in Firefox, mozilla firefox, tab button

Mozilla Firefox: Video problems, active x control, achilles tendon
Mozilla Firefox: Video problems, active x control, achilles tendon, adobe plugin

Mozilla Firefox: website on non standard web port cannot be seen by Firefox, url bar, commas
Mozilla Firefox: website on non standard web port cannot be seen by Firefox, url bar, commas, network security

Mozilla Firefox: favorites, dialog 6, export bookmarks
dialog 6, export bookmarks, export dialog: Hi Douglas, It s a quite simple process. Just follow these instructions: 1- Open your IE, click on the File menu and open the Import and Export dialog. Click Next. 2- Select Export bookmarks from the list. Next again. 3- Select the top folder (I think...

Mozilla Firefox: favorites, extension index, gmail
extension index, gmail, google: Hi Jeff, Thank you. Not being a user of GMAIL, I came up with the following sites for information: http://google.blognewschannel.com/index.php/archives/2005/10/10/google-adds-tagging/ http://www.spreadfirefox.com/node/20313 http://www.econsultant.com/i-want-firefox-extension/index.html...

Mozilla Firefox: firefox addons, firefox addons, stumbleupon
firefox addons, stumbleupon, youtube: Hi Jeff, It really depends on what you like to do on the internet, however i will recommend ones that everbody should have. First, Stumbleupon is the best addon ever. You select categories of websites you like, hit the stumble button and it brings up a...

Mozilla Firefox: firefox browser opens to slowly, firefox broswer, version windows xp
firefox broswer, version windows xp, windows kernel: Hi Stanley, Firefox will be definitely slower than IE on a windows machine because, IE is integrated with the windows kernel! However the speed difference should not have been so pronounced. Please give me the specification of your machine....

Mozilla Firefox: firefox browser problem, browser problem, character encoding
browser problem, character encoding, windows cd: Hi Abul, This problem is common when your computer doesn t have the fonts for showing some kind of characters. From Firefox, you can try to change the character encoding from the View menu, select character encoding and then look for Unicode, or Unicode-8...

Mozilla Firefox: firefox favorites, question pool, geek squad
question pool, geek squad, old computer: Hello Valerie, Your question was sent to the question pool because the expert you chose was unable to answer. I have taken the responsibility of answering. Anyway on to your question. I am going to assume you are talking about bookmarks , and all of...

Mozilla Firefox: firefox not loading pages fully, open browser windows, hi chris
open browser windows, hi chris, nothing works: Hi Chris, Upgrading to Firefox 2.0 is known to cause this sort of issues if installed over a previous installation of firefox. If this is the case, uninstall firefox 2.0 uninstall any other previous version as well, reboot and do a fresh install of 2.0....

Mozilla Firefox: firefox page bouncing, using activex controls, windows commands
using activex controls, windows commands, graphical content: Hi Scott, Well, at first this seems because some webpages are what the IT call Internet Explorer optimized . This means all the source code from the website is built in a way that only IE understands, yet using ActiveX controls (for some graphical content)...

Mozilla Firefox: firefox, mozilla mail client, internet explorer 2
mozilla mail client, internet explorer 2, support activex: Hi Jeff, These are good questions. I ll do my best to answer you. 1- Firefox is better regarding the user s experience, and because some facts you can check for yourself like a built-in pop-up blocker, a friendly interface with tabs, a fully configurable...

Mozilla Firefox: firfox contact, email support, firefox
email support, firefox: Anthony, They don t offer an email support system that I know of. But they do offer various other methods to get support. Check out http://www.mozilla.org/support/firefox/ I hope this helped. If you have any questions at all let me know. Harve...

Mozilla Firefox: gray area below status bar, gray area, java version
gray area, java version, java javascript: Hi Jeff, This is appearing as a quite common bug lately and I don t really don t know the reason, although I know that the cause is the Java/JavaScript machine that Firefox runs. I d suggest you to download the latest Java version from here: http://www.java.com/en/download/index.jsp...

Mozilla Firefox: WHY THE HELL DOESNT IT WORK!!!, web browser settings, network connector
web browser settings, network connector, proxy settings: Hi Christina, There s no need to feel sad, but just look for a solution. The message server not found is the way the browser has to tell you that it can t reach the internet or the destination. I guess that you can browse Internet with Internet...

Mozilla Firefox: home page, kamal, suggestion
kamal, suggestion: Hi Kamal, I ts quite easy: just open the Options dialog from the Tools menu, select the tab labeled Main (on the left). You will find a text field where you can specify your homepage. Suggestion: if you first visit the page you want to use as homepage...

Mozilla Firefox: Iam unable to open mozila, antivirus software, firefox
antivirus software, firefox, traces: Hi Srikanth, I m afraid that look like a virus or at least like somebody making a joke. Any program from the Mozilla Corporation would put a message like that on their software. I recommend you to uninstall it, wipe all traces of that pretended-Firefox...

Mozilla Firefox: Keyboard Shortcuts and some other question, mozilla community, mozilla development
mozilla community, mozilla development, keyboard shortcuts: Hi Sinn, I ve been looking for your answer and it seems like Firefox doesn t have neither a tool or shortcut to open a new window with the same URL on it. But that s why the Mozilla community is so great: there s an Add-on for doing that :) Find it...

Mozilla Firefox: Keyboard Shortcuts and some other question, keyboard hotkeys, keyboard shortcuts
keyboard hotkeys, keyboard shortcuts, blank window: Hello Sin, As far as the keyboard hotkeys, i assume you are talking about firefox being the one that brings up the homepage. In firefox, using ctrl n you can only either bring up the homepage or a blank window, you cant bring up one with the same URL. ...

Mozilla Firefox: Linking from Outlook to FireFox, hyperlink dialog, right click menu
hyperlink dialog, right click menu, traveling in italy: Hi Pat, I just noticed that the hyperlink dialog does not give you the right click menu to paste! Strange. However there is a work around. Copy the URL that you need, Select the URL textbox in the Hyperlink dialog and press ctrl and v together....

Mozilla Firefox: I have a laptop with a USB..., scrapbook pages, memory stick
scrapbook pages, memory stick, usb port: Jeff, If you know how to network your laptop to your desktop you can easily traansfer the files from your desktop to the laptop. From there you can network the laptop to the other computer then upload the files. If you don t know how to do this I can walk...

Mozilla Firefox: logging in, temporary internet files, dell laptop
temporary internet files, dell laptop, deleting cookies: Hi Katherine, I hope I can be of help to you. Try deleting cookies and deleting your temporary Internet files. That sounds simple but with this kind of problem it can work at times. Write me back to let me know if this worked. I will assist you till the problem...

Mozilla Firefox: McAfee Firewall Alert and FireFox, desktop firewall, application name
desktop firewall, application name, network application: Hi Ann, Firewalls are built such that each and every program that accesses the Internet should be explicitly marked as allowed in the firewall properties. Most firewalls have a console where you have to specifically select which applications can access...

Mozilla Firefox: McAfee/firefox, mcafee virusscan, hi tim
mcafee virusscan, hi tim, anti virus: Hi Tim, At first, is a hard question to answer. I ve searched some information for you, hope it helps: To allow Firefox downloads through McAfee: http://kb.mozillazine.org/Firefox_hangs#McAfee_Anti-virus A guy who found a problem interacting Firefox...

Mozilla Firefox: Menu item appearing on firefox, pc optimizer, registry key
pc optimizer, registry key, apologies: Hi Denise, Apologies for not answering your question yet, but I m not sure about what is your question about... Could you please tell me what was the previous problem (I couldn t find a past question from you in my inventory) and what s all this about?...

Mozilla Firefox: Menuitem bar appearing suddenly, reply thanks, annoying thing
reply thanks, annoying thing, java applet: Hi William, After looking that screenshot, I m almost sure that what you see under you statusbar is something like an error console, or a debug panel. I mean, something is wrong with that update (bad programmation, an error in the code... whatever) and...

Mozilla Firefox: MICROSOFT OUTLOOK, mail icon, email programme
mail icon, email programme, microsoft products: Hi Terry, Since Firefox is a Software Project not linked to Microsoft products, it needs to be managed by an Add-on. I ve searched the list of available ones and found one that I think you may find quite interesting for this purpose. Please try it out...

Mozilla Firefox: Mozilla FireFox won't work, lan configuration, options network
lan configuration, options network, menu tools: Hi Cassie, If you can connect to the Internet using Internet Explorer and Firefox can t, it may probably be the proxy configuration. Could you please check it and specify to Firefox how to connect outwards? To find this configuration in Internet Explorer...

Mozilla Firefox: Mozilla Firefox, bhagvat
bhagvat: Hi Bhagvat, Check out the following sites for information on how to make your site to be viewed, no matter which browser is used: http://www.thesitewizard.com/webdesign/multiplebrowsers.shtml http://hotwired.lycos.com/webmonkey/ http://www.websiteoptimization.com/services/analyze/...

Mozilla Firefox: Mozilla Firefox & Cookies, question pool, employment listing
question pool, employment listing, click options: Hello John Pierre, Your question was sent to the question pool because the expert you chose was unable to answer it. I have taken the responsibility of answering. Anyway, on to your question. These instructions are based on the most recent version of firefox,...

Mozilla Firefox: Mozilla Firefox Problem, servlet java, 512 mb ram
servlet java, 512 mb ram, disabling javascript: Hi Nabil, It s strange that your browser can take so much CPU as to block the system... At first, this could be caused by a lack of memory, are you running below 512 Mb RAM? Or maybe Windows Vista with less than 1Gb RAM? If that s not the case,...

Mozilla Firefox: Mozilla Firefox not responding, modem router, apologies
modem router, apologies: Hi jkuppala, I m afraid it s impossible to guess what the problem could be with this information. Could you please provide more details regarding your connection type, modem/router, what kind of site you re visiting, when does it happen, ... Apologies...

Mozilla Firefox: Mozilla Firefox showing a "menuitem" bar ?, firefox extension, reply thanks
firefox extension, reply thanks, java plug: Hi Theelepan, I m afraid the problem is the same: something related to Java console rises up an error and shows it in your browser. It may be due one of the following reasons: - your Java plug-in has updated automatically --- solution: install a...

Mozilla Firefox: Mozilla/Firefox, default browser, click tools
default browser, click tools, internet explorer: Hi Jeff, You can have more than one browser on the computer, you will not lose any Favorites and/or Bookmarks(as they are called in Firefox. You can keep Internet Explorer as the default browser. If you decide to make Firefox the default browser, that...

Mozilla Firefox: Mozilla Toolbar Query, keyboard shortcuts, mozdev
keyboard shortcuts, mozdev, saurabh: Hi Saurabh, At the following site, scroll down until you see, MenuX - 0.1.2.4 : http://www.mozdev.org/status/2005-05-12-status.html Check out the following also: http://castlecops.com/t108295-Mozilla_Firefox_Keyboard_Shortcuts.html Hope this...

Mozilla Firefox: Mozilla, free virus scan, symntec
free virus scan, symntec, mozilla browser: Hi Jennifer, You are not alone, Firefox 1.5 BETA does use a lot of memory, which can crash/freeze a computer with low memory. Check out the following for more information: http://internetweek.cmp.com/shared/article/printableArticleSrc.jhtml?articleId=175007058...

Mozilla Firefox: moving icons, home icon, lorry
home icon, lorry, separators: Hi Jeff, What I explained to you earlier is how to put icons for different sites on the toolbar. Most sites do not habe a special looking icon, just the one you see before the http of the address. Perhaps this is the information you are looking for,...

Mozilla Firefox: mozilla firefox, mozilla firefox, bensimhon
mozilla firefox, bensimhon, internet explorer: Hi S bensimhon, Mozilla Firefox is a browser, like Internet Explorer. Google is a web site that can be viewed on any browser. Many people prefer Firefox over Internet Explorer, as the people who write viruses and/or spyware are aiming for the big guy...

Mozilla Firefox: mozilla/thunderbird, tea timer, mozilla thunderbird
tea timer, mozilla thunderbird, security symantec: Hi Ena, Have you checked for viruses and/or spyware? Using Internet Explorer, go to: http://security.symantec.com/sscv6/default.asp?langid=ie&venid=sym Click the GO button, then under Virus Detection, click Start. You might be told that you need to...

Mozilla Firefox: Opening Firefox Mozilla, network error messages, tea timer
network error messages, tea timer, security symantec: Hi Roy, Check out the following for information: http://wiki.mozilla.org/Firefox:1.5_Network_Error_Messages http://lists-archives.org/mozilla-general/05769-firefox-will-not-load.html Have you checked for viruses and/or spyware? Go to: http://security.symantec.com/sscv6/default.asp?langid=ie&venid=sym...

Mozilla Firefox: how can i open mycams.com using firefox 2?, live sex chat, open websites
live sex chat, open websites, carpio: Hi Gary, I opened the web page mycams.com and from what I can see, you only need Flash Player installed in your browser. You can download the latest release from here: http://www.adobe.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash&Lang=English...

Mozilla Firefox: Problem with Firefox Cookies (presumably), netscape6, ns6
netscape6, ns6, prob: Hi Markus, With Firefox opened, go to Tools, Options, click Privacy, on the right side is Allow sites to set cookies checked? If yes, then click Exceptions, are there any sites listed there? Other than that, not sure what to offer. BTW, it s a good...

Mozilla Firefox: pictures not found, image path, image formats
image path, image formats, internet explorer: Hi Vyasa, Both Firefox and IE are capable to open the standard image formats (JPG, GIF). The first thing that I thought was that some of your images where in an other format, like PNG or similar. Another change that you can make to ensure the images...

Mozilla Firefox: problem loading page, problem loading, loading page
problem loading, loading page, dns servers: Hi Sheri, Hope I don t get frustrated too, because that problem seems to be hard to solve from the distance. Anyway, let s see a few checks you can do for yourself. If the website is providing a good service 24h a day, then something is missing somewhere...

Mozilla Firefox: reversing an adblock in Mozilla firefox, adblock, neopets
adblock, neopets, stupid thing: Hi Susan, I think you can reverse that. Open the Add-ons dialog from the Tools menu, and click the cell where appears the name Adblock . Three buttons will appear, click the one on the left: Options. There you will find a list with all the filters you...

Mozilla Firefox: Save As Music & Browser stop working., quick time pro, herat co uk
quick time pro, herat co uk, fire fox: Hi Maihan Nijat, Apologies for the late reply, I ve been really busy these days. For your first question (1.-) it s easy, you just have to open the address I specify below and save the songs by pressing right-click on each file and selecting Save...

Mozilla Firefox: Suddenly s-l-o-w internet, free anti spy ware, dell 4550
free anti spy ware, dell 4550, free anti spy: Patrick, You transcribed the whole output! I am so sorry I should have give you the steps to copy from a command window. Here is the procedure to run these commands and copying the output to a word document. 1. Click on the start button run 2. Type...

Mozilla Firefox: source code of ScrapBook(firefox add-on), mozilla project, source html
mozilla project, source html, google: Hi Gump, Sure. Since the Mozilla project and Firefox are open source, their add-ons should be too. I ve found the official page for developers to access the source code of ScrapBook here: http://scrapbook.mozdev.org/source.html You can get it both...

Mozilla Firefox: Tabs in Firefox, new tabs, tab button
new tabs, tab button, tab bar: Hi Sarah, It is true that Firefox does not come with a button to open new tabs, but all you need to do is double click on empty space on the tab bar to open a new tab!. Firefox gives you 3 ways of opening a new tab: 1. Press ‘Ctrl’ and ‘T’ together....

Mozilla Firefox: Too Many Tabs Stops Music???, change tabs, ill change
change tabs, ill change, wonderful music: Hi Dan, Well, it seems that you yourself know what the problem is: too much tabs at the same time. Anyway, I guess that the concrete issue is that there are too much connections working, a big amount of computer memory used... and that often stops online...

Mozilla Firefox: tabs, scroll wheel, mouse pointer
scroll wheel, mouse pointer, losing your place: Hi Jim, Tabs are the most talked about and utilized feature of Firefox. I will give you instructions on basic usage of tabs here. Firefox gives you 3 ways of opening a new tab: 1. Press ‘Ctrl’ and ‘T’ together. 2. Select File New Tab. 3. Double-click...

Mozilla Firefox: Video problems, public servers, video problems
public servers, video problems, windows operating system: Hi there, Rob. Please don t feel guilty, you just asked, and I m taking it as a challenge... but I m getting out of answers. I visited that website, checked several videos (including the weather forecast for Chicago... it seems there will be some showers...

Mozilla Firefox: VPS, free internet explorer, linux vpn
free internet explorer, linux vpn, desktop installation: Hi Tom, CentOS is a linux distribution based on Red Hat, so you should look for a RPM package of Firefox to install it on your VPS. If your VPN allows you to use some kind of remote desktop, installation should be quite easy. If you need to do it using...

Mozilla Firefox: on videoproblems, cbs website, flashblock
cbs website, flashblock, flash objects: Hi Trudy, I tried to visit the CBS webpage with my updated Firefox and Flash player, and it all worked fine. Then I installed the Flashblock add-on and tried again: the flash animations were blocked, and when clicked on the indicator, it started playing....

Mozilla Firefox: Website recently stopped loading in Firefox, private data, internet explorer
private data, internet explorer, checkboxes: Hi David, When I was reading your request, I tried the address salon.com and it seems to work fairly well. It s not the fastest web I ve seen, but it ends loading the page, and I can read articles. Let s try something: Open your Firefox browser, click...

Mozilla Firefox: Website not showing in Firefox, free web editors, internet explorer
free web editors, internet explorer, tdrc: Hi Vicki, Now I see what you mean: I found trouble while displaying the page The Pots (http://johndermer.com.au/products.htm) due to a missing image and the unavailability of passing to the next. I think I have an explanation for that, but I m not quite...

Mozilla Firefox: My website cannot be seen on firefox but OK on IE, preferred languages, chinese version
preferred languages, chinese version, character encoding: Hi P. Jiang, I have been investigating your website and the Firefox behavior, and it is a problem with the Character Encoding. You can change it from the View menu, Character Encoding and then selecting UTF-8 that is the one used for Chinese characters....

Mozilla Firefox: website on non standard web port cannot be seen by Firefox, web port, building a web site
web port, building a web site, web browsing: Hi Paul, I wasn t sure, so I asked a friend for his advice, they came back with: I don t have an answer. I ve used Firefox on ports other than 80 but not on the same machine as this guy is doing. I wonder if he can get to it from another computer on...

Mozilla Thunderbird: navigating between Thunderbird and Godaddy, smtp mail servers, outgoing mail servers
smtp mail servers, outgoing mail servers, outgoing smtp mail: Dear Gabe, Mozilla Thunderbird is a piece of software which enables you to send and receive mails without opening a browser. To do that you have to configure both Incoming (IMAP/POP3) and outgoing (SMTP) mail servers. Basically when you enter your account...

Mozilla Thunderbird: bulk mail, mozilla thunderbird, mail extension
mozilla thunderbird, mail extension, mass mail: Dear Gabe, There s a mass mail extension for Mozilla Thunderbird, called Mail Tweak . Please follow this link, it ll guide you with step by step instructions. http://www.makeuseof.com/tag/how-to-send-personalized-mass-emails-in-mozilla-thunderbird/...

MS SQL: MSsql doublt, microsoft sql server, microsoft sql server 2005
microsoft sql server, microsoft sql server 2005, sql server 2005: Hi Sheju See, there is a provision in Microsoft SQL Server 2005 to move rows into columns using PIVOT. But we cannot pass dynamic parameters over there (date in your case). So you need to write a dynamic sql query, which I think will be little complex....

MS SQL: Trying to conditionally format column by future date values, conditional formatting, currentdate
conditional formatting, currentdate, ssrs: /* This will first check if the Renewal date is less than currentdate+1 month, if yes then color YELLOW else go to next condition if the Renewal date is less than currentdate+2 month, if yes then color GREEN else go to next condition if the Renewal date...

MS SQL: Auto fill form in Access 2003, focus event, combo box
focus event, combo box, database user: Hi Tanu This requires some coding, basically on the lost focus event of ISBN we need to fire a query if this record already exists, if it does then populate the existing data. Otherwise just leave everything blank for the user. If you know VBA then you...

MS SQL: microsoft sql server unable to connect locally?, sql server management, microsoft sql server management studio express
sql server management, microsoft sql server management studio express, sql server 2000: Hi Peter Please check these 1. You have the engine installed (along with management studio). 2. SQL Server Service is runnig using services or task manager. 3. Try connecting using localhost and . 4. Check NamedPipe and TCP/IP is enabled. ...

MS SQL: views in mssql 2005, smallint, manoj
smallint, manoj, spoils: Hi Mai, This seems to be clearer now :) Such situations are generally handled by concatenating the values and then the application would take care in parsing. You could try something like select Trans_no, isnull(cast(Item_a as varchar(10)), )...

MS SQL: 2 Nested Queries, nested query, sql server 2000
nested query, sql server 2000, temp: Hi Richard, Please list down the names of table used in all 3 queries and the columns being used in all of the queries. So far the cause looks like is the scope of the temp table in nested queries. If this is the case, please try to create the temp table...

MS SQL: Follow-up on Views, host table, colums
host table, colums, resultset: Hmm, so you need the colums as rows now, something in conta coming in the same column in the resultset select trans_no, item_a as columa, Quantity where Item_a is not null union select trans_no, conta as columa, Quantity where Item_a is not null and...

MS SQL: Formatting Results, convert, smalldatetime
convert, smalldatetime, char: Hi Richard, There are several alternatives for the same. Here s the link on MSDN that can help. ### http://msdn.microsoft.com/en-us/library/ms187928.aspx ### You may consider to use following syntax for the same. ### CONVERT(CHAR(8), CASE_RECORD.CR_PRDATE,...

MS SQL: guid, uniqueidentifier, column
uniqueidentifier, column, new: Dear Jorg, While creating the new uniqueidentifier column in first table, mention newid() in value field, so that on addition of each row, a uniqueidentifier value will be put in the field. And thus the field will not be null anytime in this table. Feel...

MS SQL: MS SQL 2005 SYNTAX FOR JOINING, incorrect syntax, e email
incorrect syntax, e email, wikipedia: Hi Mukund Here is the syntax for INNER JOIN, please re-write you query following this example SELECT DISTINCT n.Name, a.Address, p.Phone, e.Email FROM EntityName n INNER JOIN EntityAddress a ON n.EntityId = a.EntityId INNER JOIN EntityPhone p ON a.EntityId...

MS SQL: need to slect personnelnumber from table, sql, query
sql, query, like: Dear Roy, This can be done with a SELECT query giving the wild card characters in WHERE clause, as under: ### SELECT personnelnumber from table1 WHERE temporary_staff_number like 5% ### Feel free to follow-up. Thanks, Jwalant Natvarlal Sonej...

MS SQL: Problem to solve query??, oracle, mysql
oracle, mysql, sort: Dear Amit, 1. Its really good that you have tried to put all the details related to the query here, including the table structures. But I would like to request you to provide me with the exact sequence of showing the records that you require (expected sort...

MS SQL: SQL Value Function, msaccess, query
msaccess, query, select: Dear Drew, I am very sorry, here s the simplified version of the previous answer. You should: Create a simple select query with minimum required criterias in where clause. Check value of each dropdownlist/combo from the form and then if its not blank...

MS SQL: Steps to install SQL 2005, installation wizard, server installation
installation wizard, server installation, sql server: Hi Willy SQL Server Installation wizard itself is very helpful and easy to navigate but if you still need documentation regarding the same then please refer to this link.... http://msdn.microsoft.com/en-us/library/ms143516.aspx Thanks Mohi...

MS SQL: setting up a client server network, connection string, ado.net
connection string, ado.net, database: Dear Khalid, I am glad that you tried and tested all things suggested by me, and I really like your eagerness for the workarounds. Regarding the query about the changes of authentication after installation: Yes, the login style can be changed from after...

MS SQL: sql server and ms Access, msaccess, upgrade
msaccess, upgrade, sql server: Hi Vinod, Can you please provide me with exact error message and error no received while trying to connect? Also, before upgrading the database you may consider using SQL Server upgrade assistant tool feature that can check the current database and then...

MS SQL: Auto Filled data in Access Form, table description, nayyar
table description, nayyar, microsoft access: Hi Prem My name is Mohit Nayyar and not Ayyer. You can set the default value for a field while creating your table in Microsoft Access. So everytime when you will not enter any data in these fields, it will store the default associated values. Thanks...

MS SQL: How Can I create an Auto Fill, foreign key, step approach
foreign key, step approach, cuny: Hi Edwin I guess you are looking for step-by-step approach. So, please look at these links... http://cisnet.baruch.cuny.edu/holowczak/classes/2200/access/accessall.html#sec_forms http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm...

MS SQL: DBMS, relational data model, model competition
relational data model, model competition, world scenario: Dear Sofia, Relational Data Model has definite competency over the others as the it symbolizes the real world scenario. For example, find information regarding your self, and you will find that the each piece of data is somehow related and/or dependent on...

MS SQL: insufficient system memory, sql server configuration, insufficient memory
sql server configuration, insufficient memory, server memory: Hi Massoud Please also check your physical server memory, CPU and the memory/CPU available to SQL Server. The resources available to SQL Server depends upon the SQL Server Edition and your SQL Server configuration. If things are already fine then you...

MS SQL: Proper memory usage setting, microsoft sql server, proper memory
microsoft sql server, proper memory, usage option: Hi Tim I generally do system cache on my servers (win 2003-sql 2005). And these servers only host SQL and not other server applications etc. System cache primarily works best with Windows server product. I recommend using Microsoft SQL Server forums...

MS SQL: SQL Query, time attendance software, nayyar
time attendance software, nayyar, coloumns: Hi Binu As per your question you just need the first IN and last OUT time for the day....please check this given example for the solution create table #temp ( col1 varchar(10), col2 varchar (10), in_out varchar(10), in_out_date datetime ) GO ...

MS SQL: Cant remove this user, sql server error, microsoft sql server
sql server error, microsoft sql server, database owner: Hi Dan You can easily solve this orphaned users issue with visiting any of the following links. I request you to understand it first and then implement, you can also replicate the same issue with a new database. http://vyaskn.tripod.com/troubleshooting_orphan_users.htm...

MS SQL: CUMULATIVE SUM MONTHLYWISE, cumulative sum, cumulative value
cumulative sum, cumulative value, select sum: Hi Mohamed, There can be one way with the use of inner sql, if there is any integer identity column (or use month no. to track the same). It may be done like this: ### Select Month, value, cumValue= (select sum(t1.value) from table T1 where t1.monthno...

MS SQL: CUMULATIVE SUM MONTHLYWISE, cumulative sum
MS SQL: CUMULATIVE SUM MONTHLYWISE, cumulative sum

MS SQL: Payments Query, thanks in advance
thanks in advance: Hi Alp, Here you need to use grouping on the username and select max of date and username with it. The date criteria can be given with having keyword. It may look like this: ### Select username, max(date) from userstable group by username having...

MS SQL: Calculation Query - Separate or not?, two tables, agri
two tables, agri, business requirements: Dear Enrico, As you may know, decision of how to write the queries will mostly depend upon your business requirements coupled with how you are going to execute the query. If you divide the whole in to two queries then what you will be getting is two tables...

MS SQL: calculation query, select statement, agri
select statement, agri, inv: Hi SELECT CASE WHEN CoOwner = 1 THEN NoofBags/2 ELSE NoofBags END AS Bags , Invenvtory - NoofBags - (CASE WHEN CoOwner = 1 THEN NoofBags/2 ELSE NoofBags END) FROM agri See the above query is just an example to do multiple things in a single...

MS SQL: Looping Update Query, column names, column name
column names, column name, sanjay: Dear Sanjay, You need to take concate all column names separated by | (some sign) and then use while loop to fetch one columnname and update it and remove it from the list. This way the whole list can be operated. Feel free to follow-up. Thanks, Jwalant...

MS SQL: I need a help, folder path, destination folder
folder path, destination folder, source server: Dear Mahiendiran M, I assume that you have the query ready with you to fetch data from the tables. There is export data wizard in SQL Server Management Studio (SQL Server 2005 and 2008) and Enterprise Manager (SQL Server 2000, not sure for SQL Server 7)...

MS SQL: query that will return 0, value1, oracle database
value1, oracle database, null value: Dear Enrico, I would like to request you to tell me what is expected from the having HAVING (sum(tblseedsubsidy.NoOfBags) /2);. As the ; is used, i guess it should be an oracle database query. In SQL Server there is system function called as IsNull()....

MS SQL: sql server mirroring, principal server, witness name
principal server, witness name, disk c: Hi Hema, This is more to do with configuration and missing some step...I really can t do much in this. I request you to follow standard steps given in SQL Server BOL to complete the process. Setting up mirroring is the really easy if followed the steps...

MS SQL: Question on Database, memory, table
memory, table, char: Dear Sachin, For char, it will require the size that has been declared in table desing. BigInt, not sure, but will require less space. More information can be found from this article: http://www.databasejournal.com/features/mssql/article.phpr/2212141 ...

MS SQL: SQL query to extract records with specific values in two columns, filter conditions, parantheses
filter conditions, parantheses, payr: Hi Sandi, To check only this, please remove all joins and select only from this table only for that condition. It will and should work. After that you could change the query to include other tables and other filter conditions. Something else is wrong...

MS SQL: complicated query?, question, answe
question, answe: Dear Vijay, I appreciate you efforts to make me understand the requirement. But the thing is that its still not clear that 1. What is P1, what is r1? 2. When you say each question has subquestion, how exactly they are related? 3. What I understood is you...

MS SQL: One invoice number for multi shops, invoice, no
invoice, no, repeat: Hi Nora, How the repetition can be removed depends upon what kind of architecture you are using. The problem seems to be of same no is generated either by the front-end system or by the database. 1. If the front-end is generating the invoice no, depending...

MS SQL: Queries in using SQL Server 2005 with front end with advanced services like mirroring, database, sql server 2005
database, sql server 2005, backup: Hi Khalid, Its good that you have such a good interest in SQL Server and have done certification in the same. I would recommend you the following: 1. For GUI learn any programming language (NOT database programming language like - SQL, PL/SQL). If you are...

MS SQL: SQL Trigger to insert data in another table, trigger, table
trigger, table, insert: Dear Jeevan, Trigger will be executed for each insert. So as per that for example if 50 rows are going to be inserted in your table A, the trigger which keep looking on table A will be fired 50 times. In this case, you don t need to worry about the update...

MS SQL: SSRS Query help, duedate, account thanks
duedate, account thanks, crm system: Hi Jack You can use the same SQL query in SSRS report. And I guess you can use GROUP BY and MIN to get the desired result. SELECT Account, MIN (DueDate) FROM TableName WHERE DueDate IS NOT NULL GROUP BY Account The above query will give...

MS SQL: sql derver2000 &asp.net (c#), table schema, salary details
table schema, salary details, attendance record: Hi Rahul This is easy you just need to join the first two tables to get the number of days one employee is working. And based on the above information you need to make a join with Salary table to calculate the final salary. You need to use the MONTH...

MS SQL: ask a answer this question, sql dbo, bulk insert
sql dbo, bulk insert, server table: Hi I didn t understand your question but I think that you need to move your data in text file to SQL Server table. If the above assumption is true then there are many options in SQL Server to do so like BULK Insert, BCP, Import/Export etc. Thanks...

MS SQL: Beginning SQL Server, sql server products, data warehousing project
sql server products, data warehousing project, sql server reporting services: Hi Charles I made a right decision, there is great future in Business Intelligence related work and Microsoft is doing really good in this field. I request you to brush/migrate your Access SQL Query skills to Microsoft SQL Server. See, whats more you...

MS SQL: concatenation, david stern, semi colon
david stern, semi colon, resultset: Hi Ohad, You would not be able to achieve this using your select statement, since your data is stored row-wise. To achieve what you are looking for, you are better off creating a temporary table with a colum which holds the concatenated values. Then...

MS SQL: converting resultset to a single field in a statement, concatenate, semicolon
concatenate, semicolon: Dear Ohad, You can use a varchar with a while loop with count of the records found for the author. This should pull out the books id one by one and then concatenate them and put in to the varchar. Feel free to follow-up. Thanks, Jwalant Natvarlal Sonej...

MS SQL: Default, database, table
database, table, constrain: Dear Jorg, I have not tried this, but may serve the purpose. Steps: 1. Create a script for creating constrains for the particular table, it will not have constrains for the removed column. 2. Create a scrip to remove all constrains from the particular...

MS SQL: Default, microsoft sql server, microsoft sql server 2005
microsoft sql server, microsoft sql server 2005, constraint name: Hi You can use this query to fetch information about table, columns and associated defaults and then using a cursor can delete the columns.... select object_name (t.object_id) Table_Name, c.Name as Column_name, object_name (c.default_object_id) as Default_Constraint_Name...

MS SQL: SQL query to fetch duplicate data only, incorrect result, duplicate records
MS SQL: SQL query to fetch duplicate data only, incorrect result, duplicate records, sql query

MS SQL: Calculate 5 highest numbers, table, highest number
table, highest number, order by: Dear Ola, The above given query should work for this purpose, but has to be modified according to your columns in result and in table. For example: #### SELECT TOP 5 Animal_Name, Animal_Weight FROM Animals ORDER BY Animal_Weight DESC #### Try...

MS SQL: Query for fetching 2nd largest , 2nd lowest data, Max, Min
Max, Min, salary: Dear Mrinmay, There will be (and are) several ways to get the same results. I will illustrate one of them here. I believe it would not be the best one but can be used for your both queries, with less modification required. 1) Find the top salary and it...

MS SQL: SQL Query, phoneno, petname
phoneno, petname, select sum: Hi Ola, SELECT C.CustomerName, C.PhoneNo, P.PetName, P.DOB, P.Gender, Group1 = CASE WHEN (SELECT SUM(Weight) FROM Pets P WHERE C.CustomerNo = P.CustomerNo) 2KG THEN WEIGHTY WHEN (SELECT SUM(Weight) FROM Pets P WHERE C.CustomerNo = P.CustomerNo)...

MS SQL: SQL Query to Get Incremented Index based on other Column value, SQL Server, SQL
SQL Server, SQL, SELECT: Dear James, There could be several types of queries leading to the same result. One of them can be like this. 1. Create temp table 2. Insert data in it. Create an extra column in it to store the intended new column in it. 3. Select query on this temp...

MS SQL: SQL query to fetch duplicate data only, employee, duplicate value
employee, duplicate value, list duplicates: Dear Mrinmoy, Here you can use GROUP BY with COUNT to get the desired result. For example: ### SELECT batch_code, cusip, age, salary FROM Employee WHERE cusip IN (SELECT cusip FROM Employee WHERE COUNT(cusip) 1 GROUP BY cusip) ### This will fetch details...

MS SQL: triggers, binary fields, binary field
binary fields, binary field, test3: Hi Oliver I didn t understand your question completely, so please check my answer on some basic assumptions. You need to use COLUMNS_UPDATED or UPDATE() to check if the binary column has been updated/inserted. And then you can take the action accordingly...

MS SQL: Looking for Quiz or any small project related to SQL Server, guidiance, membership plan
guidiance, membership plan, knowledges: Hi Sanlen There are multiple ways to do this. 1. Generally every SQL Server book has some quiz at end of each chapter, so try solving that by writing queries, procedures etc. 2. Restore the Northwind / AdventureWorks database on your machine and based...

MS SQL: Access & SQL, scale applications, access sql
scale applications, access sql, manoj: Hi Peter, There are quite a lot of differences between them. Access is more of a light weight RDMS wehereas SQL server could be used for large scale applications and is being used extensively in large installations. Some useful articles would be ...

MS SQL: count dates that occured more than once between 2 given dates in a table, sql server, group by
sql server, group by, order by: Dear Rodvalencia, 1. All rows when movie copy rented before it was returned. ### SELECT RE.* FROM RENTAL RE INNER JOIN (SELECT RD.Movie_No, RD.Copy_No MAX(RD.Return_Date) FROM RENTAL RD WHERE RE.Rental_Date RD.Rental_Date GROUP BY RD.Movie_No, RD.Copy_No)...

MS SQL: differences among releases, sql server, compare edition
sql server, compare edition, feature comparision: Hi Willy, I am not able to provide all feature comparison. But I would like to provide pointer that may be helpful to you. ### http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/ http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx...

MS SQL: SQL 2000..option create new database, security credentials, sql servers
security credentials, sql servers, option database: Hi Willy You need to register the server with enterprise manager, that means now you can access not only SQL Server you installed on your machine but any other SQL Server available on the network (provided you have all security credentials). If you can...

MS SQL: SQL Programming, sp who2, technet microsoft
sp who2, technet microsoft, concurrency issues: Hi Kumudha This document has good explanation of SQL Server transactions. http://technet.microsoft.com/en-us/library/ms188929.aspx You can use sp_who, sp_who2, sp_lock etc. to check for locking/concurrency issues and implement transaction using the...

MS SQL: Capturing Search String entered in UI, sql server, UI
sql server, UI, search string: Dear Arun, Sorry for very late reply. It depends on the UI architecture how you can grab the search strings. You may grab the string user entered and store in the XML for a while and then pop them up in the database after sometime. OR Grab all inputs...

MS SQL: Connection, rashid khan, pune india
rashid khan, pune india, system config: Hi Rashid It looks like that the machine doesn t have the required provider. Try changing the provider to SQLOLEDB and see if works. Its good to use Native SQL Client if you are going to use the new features provided by this. Even installing the SQL...

MS SQL: unmatched queries, unmatched records, case statement
unmatched records, case statement, sql statement: Hi Ken Apologies for delay in response. You have to use IN or OR operators and can use the same in Case statement to get YES/NO type results. SELECT CASE WHEN Id = Group1 THEN Yes AS Group1, CASE WHEN Id = Group2 THEN Yes AS Group2 FROM ......

MS SQL: Reporting Services Query, services query, installation mode
services query, installation mode, level thanks: Hi Can you please check the Report Services Configuration Option and make sure that the user trying to access has required permissions and everything is setup over there. Can you also explain the RS installation mode that you have used and any IIS...

MS SQL: SQLServr process, scenerios, tuning techniques
scenerios, tuning techniques, memory usage: Hi Ally Apologies for the delay. First of all you should check the memory counters and analyze the pattern on memory usage. And there are some scenerios in which SQL Server will not return the memory back to OS. But you can restrict the memory used by...

MS SQL: multiple sum of fields from different tables, direct sum, header table
direct sum, header table, multiple records: Hi Peter You just need to JOIN the 2 tables and then use GROUP BY along with SUM to get the desired result. But I think you will have multiple records in DETAIL table for a single record in HEADER table. So, doing a direct SUM will bring wrong result,...

MS SQL: query recordset problem, sql server, read rows one by one
sql server, read rows one by one, temp table: Dear David, Sorry for reply very very late. As per the requirement, using a temporary table will help. What you will need is to read first line in the recordset and if site is not present in the temp table, then add the row to it. If the site is present...

MS SQL: Compare 2 tables, sql server, stored procedure
sql server, stored procedure, insert: Dear Irina, I have modified the query to make some specific changes. Here I would like to mention that as the intention is to update the information in the table tblArchivedRecords and to insert new records in the same table in case records are found in...

MS SQL: SQL time manipulation, time manipulation, 2 steps
time manipulation, 2 steps, pseudo code: Hi Michael I guess you can do this in 2 steps. So here is the pseudo code 1. If you need to check based on date values with existing database value e.g WHERE convert(varchar(10), TimeFrom, 121) = convert(varchar(10), NewDate, 121) OR convert(varchar(10),...

MS SQL: Trigger to datestamp field in SQL 2005 table, firstname lastname, magic table
firstname lastname, magic table, error msg: Hi Irina I request you to go through some quick reference SQL Server book as I see some basic syntax issues in your queries. I really don t understand this........... IF not exists (select * from dbo.tblArchivedRecords where dbo.tblArchivedRecords.LogonName=dbo.AD2SQL.LogonName)...

MS SQL: Trigger to datestamp the field in SQL 2005 table, sql server 2005, update
sql server 2005, update, trigger: Dear Irina, You may find more reference at the below link: ### http://www.developmentnow.com/g/95_2004_7_0_0_379150/Creating-a-simple-update-trigger.htm ### Your trigger may look like below: ### ALTER TRIGGER [dbo].[updateTimeStamp] ON [dbo].[tblArchivedRecords]...

MS SQL: Trigger to datestamp field in SQL 2005 table, memory resident, column name
memory resident, column name, stamps: Please use this : ALTER TRIGGER [dbo].[updateTimeStamp] ON [dbo].[tblArchivedRecords] FOR INSERT,UPDATE AS BEGIN SET NOCOUNT ON; UPDATE tblArchivedRecords SET [TimeStamp] = GETDATE() FROM tblArchivedRecords join inserted on tblArchivedRecords. unique...

MS SQL: from MS access DB to SQL, ms access, sql server
ms access, sql server, migration: Hi Bahgat, Nice question! I think this link can serve the purpose. ### http://support.microsoft.com/kb/237980 ### Also, if you want to migrate just data then there could be another way - that is to use import wizard in sql server. Just right click...

MS SQL: Replace numbers with text in a query, column name, digit number
column name, digit number, tbl: Claudia, You could do something like select a , replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(a, 1 , one ), 2 , two ), 3 , three ), 4 , four ), 5 , five ), 6 , six ), 7 , seven ), 8 , eight ), 9 ,...

MS SQL: Stored procedure returning duplicate records, distinct category, duplicate records
distinct category, duplicate records, schema: Hi Kulvinder I guess you are missing the join between Services and Category SELECT distinct Category.CatID, Services.ServiceID, Services.ServiceName, Services.StreetRoad, Services.Area, Services.Town, Services.PostCode, Services.ServiceKeywords FROM...

MS SQL: HTTP Post and Request, sql server 2005, ms sql
MS SQL: HTTP Post and Request, sql server 2005, ms sql, web service

MS SQL: HTTP Post and Request, sql server services, sql server express
sql server services, sql server express, code web: Alicia As I said there is built in support in SQL server for XML data and combining this with ADO.Net or SMO can give you everything you need. Please take a look at these 2 links to understand this in more details.. http://msdn.microsoft.com/en-us/library/ms345137.aspx...

MS SQL: ms sql query to convert time differences into hrs, sql query, varchar
sql query, varchar, time differences: Hi I think you can combine the StartDate and StartTime along with EndDate and EndTime then find the time difference. But I don t understand how come you come up with 9 hours.... Please check this script and I am sure you can use this somehow declare...

MS SQL: User Prompt, sql server reporting services, sql server 2000
sql server reporting services, sql server 2000, microsoft sql server 2000: I think you mean Microsoft SQL Server 2000. Well, if my assumption is true then you need a UI for the this requirement. A front-end application will best meet your requirement, you can also use SSRS (SQL Server Reporting Services) for this with certain...

MS SQL: adding triggers, ms sql server, schema name
ms sql server, schema name, microsoft: Hi Kalyan Definition of trigger itself has the association with table, so nothing specific you need to do. CREATE TRIGGER [ schema_name . ]trigger_name ON { table | view } Please look at this example to understand the same in more detail. http://msdn.microsoft.com/en-us/library/ms189799.aspx...

MS SQL: Creating a Variable, value money, retrieval operations
value money, retrieval operations, variable assignment: Hi Richard This is easy... DECLARE @Value money, @EndDate DATETIME SET @EndDate = GetDate() SELECT @Value = CASE WHEN Date_Voided @EndDate THEN TEMP.PROF_COMP WHEN Date_Voided = @EndDate THEN 0 END FROM Table1 SELECT @Value --to validate...

MS SQL: My sql Query, partition tables, partition table
partition tables, partition table, transalation: Hi Gaurav, The better option which I feel, based on limited overview about your system is going based on partition tables. There would be an overhead in the transalation during inserts, but that would be scalable considering adding a table for every rule....

MS SQL: MS SQL Server Management Studio Express Login, sql server management, sql server error
sql server management, sql server error, ms sql server: Hi Deepti, It sounds like some installation or dll corruption issue since one of the dlls could not be loaded. There are several folks complaining about it but I did not see a proper resolution as well. Verify the existence of the dll and in the right...

MS SQL: DBLINK from SQLServer to Oracle 8i, oracle dba, oracle 8i database
oracle dba, oracle 8i database, oracle 9i: Hi Racquel It looks like the connectivity issues and I would suggest that you should talk to Oracle DBA and your network team for TNS related issues. I won t be able to answer any technical queries related to Oracle, I only work on Microsoft technologies....

MS SQL: Creating A Search Query, string manipulation, combo boxes
string manipulation, combo boxes, configuration table: Hi Yamuna I can t say that you are using correct approach as I see SQL Injection level issues with it, but still I have seen people doing the same. But I request you to look into your business requirement again and come up with simplified solution. Have...

MS SQL: convert oracle query to MS SQL, sql server, oracle
sql server, oracle, convert query: Dear Richard, There does not seem to be any big changes required. Below could be the changes: ### SELECT library , event_date , count(et_50) AS Loans , count(et_52) AS Returns FROM (SELECT library , event_date ,(CASE WHEN event_type...

MS SQL: Move/copy database mssql2005 yo mssql2008, database wizard, copy database
database wizard, copy database, dbs: Hi Trinh, There are few ways to do this. In SQL 2008 there is a copy database wizard which you could use to move the DB. OR you could detach the DBs from SQL 2005, copy the files to where your SQL 2008 is located and then attach them in your SQL 2008...

MS SQL: Copy data to Mysql server database, evaluation versions, default time
evaluation versions, default time, server database: Hi Srinivasa Apologies for delay. You can easily use ADO.Net to store and retrieve the information using SQL Server. Once you get the message, insert the same in SQL table and other column can use default time (getdate()). Afterwards you can use the...

MS SQL: SQL Server 2005 - temp table error message, subquery, temp table
subquery, temp table, sql server 2005: Hi Richard This error has more to do with the subquery and not temp. table. So, just check what your subquery is returning and accordingly you can make the change e.g. SELECT Col1, Col2 FROM TableName1 WHERE Col1 = (SELECT Col1 FROM TableName2) ...

MS SQL: DBMS, database models, database schema
database models, database schema, db objects: Hi Sandeep, These two cannot be compared as they mean different. Database schema are the logical structure of entities (like tables or other Db objects) and their relationships in a database As for database model (from Wikipedia) it s defined as ...

MS SQL: DBMS, data access page, custom dialog box
data access page, custom dialog box, combo box: Hi Sandeep List Box: Select existing value(s) Combo Box: Mix of text and list box, so you can also type along with selecting an existing value In many cases, it s quicker and easier to select a value from a list than to remember a value to type. A list...

MS SQL: sql query, varchar
MS SQL: sql query, varchar

MS SQL: SQL server 2005 - Magic Table, magic table, insert
magic table, insert, update: Hi Sagar, As per my knowledge, the magic tables are internally created when there is an INSERT or DELETE operation on database. I also suspect that a magic table is created when there is an UPDATE operation is executed as well. And you currently said, magic...

MS SQL: sql query, sql server, table1
sql server, table1, table2: Dear Sam, Sorry for very late response. What is the mechanism to update table2? You will need a column to identify which are the new rows OR You will need to perform LEFT JOIN and then exclude rows already present in the table2 from getting entered...

MS SQL: Complex Select Statement, SQL Server, Excel
SQL Server, Excel, Migrate: Dear Sami, I am providing my understanding of the query here: ### 1. Two table with similar kinds of data columns 2. You need to show the data from both tables adjacent (side by side: table A columns and then table B columns) 3. Both table have data...

MS SQL: Complex Select Statement, number column, blank line
MS SQL: Complex Select Statement, number column, blank line, time and date

MS SQL: Grouping by a calculated field, base query, evenstart
base query, evenstart, col3: Hi Alexandre I need to understand the function details. But if you need urgent help then just write another query on top of base query you have and then use GROUP BY. Example -------------------------------------- SELECT NewCol1, COUNT(Col2) AS...

MS SQL: Query question, Excel, Access
Excel, Access, Stored Procedure: Dear Kathy, Sorry for late reply. You may create a View in Access or a Stored Procedure to ease the parametrization of the query. ### http://office.microsoft.com/en-us/access/HP010322231033.aspx ### Also, what else can be done is to create a table...

MS SQL: Excel vs SQL, microsoft sql server, excel expert
microsoft sql server, excel expert, business database: Hi Red From a row/column perspective you can say that they are same but Microsoft SQL Server is an enterprise level RDBMS (not speadsheet like MS Excel) solution. Imagine you need to have over 1 billion rows in excel, not doable right (unless you know...

MS SQL: sql server 2000 database, sql server 2000, attach
sql server 2000, attach, ldf: Hi Sathik, Sorry for very very late reply. The SQL Server log files have .ldf extension, and data files have .mdf extension. So, rename your files like this: 1.budget_log.bak -- budget_log.ldf 2.budget.bak -- budget.mdf You may move them...

MS SQL: sql server 2000 database, technet microsoft, sql server 2000
technet microsoft, sql server 2000, cs 555: Hello Sathik, Based on the extension mentioned they seem like backup files. You could restore them in SQL 2000 if the backups were from SQl 2000. And the way to restore them could be found in Books Online for SQL 2000. Some useful articles are http://www.dell.com/content/topics/global.aspx/power/en/ps4q00_martin?c=us&l=en&cs=555...

MS SQL: tunning, dynamic sql statements, microsoft sql server
dynamic sql statements, microsoft sql server, union clause: Hi Saleem There could be lot of reasons begind poor query performance, sometimes its indexes, stats, poorly written query, hardware limitation etc. I have a checklist, please use this to troubleshoot your query. 1. Large Result Set 2. Missing Where...

MS SQL: Complex Query, hlr, mgw
hlr, mgw, varchar: Hi Rajesh Just create a view based on 4 tables and then query that view. Simple :) Create View vNOC AS SELECT NOC_CMD, NOC_CMD_text, NOC_CMD_Remarks FROM MSS UNION ALL SELECT NOC_CMD, NOC_CMD_text, NOC_CMD_Remarks FROM MGW UNION ALL SELECT NOC_CMD,...

MS SQL: MSSQL Transaction Log Backup, recovery model, msdb
recovery model, msdb, content table: Hi Diana Apologies for delay. If you just forget the backup location then use these tables in MSDB to get the details. select * from backupfile select * from backupfilegroup select * from backupmediafamily select * from backupset Otherwise,...

MS SQL: SQl query where backend is MSaccess, field c, string value
field c, string value, datatype: Try this, And I assume the datatype for col C is varchar/char (essentially a string value) since you have padded zeros in the front. select * from table where substring(ColC, 3,1) = 1 This will give you what is required. Regards, -Mano...

MS SQL: SQl query where backend is MSaccess, field c, access functions
field c, access functions, b2: Hi Shailesh You can use RIGHT/LEFT function to achieve the same. SELECT LEFT (RIGHT (Col1, 2), 1) FROM TableName SELECT * FROM TableName WHERE LEFT (RIGHT (Col1, 2), 1) = 1 Please refer to this link for more functions. http://www.techonthenet.com/access/functions/index.php...

MS SQL: mySQL query search, MySQL, SELECT
MySQL, SELECT, Mulitple criteria: Hi David, I am very sorry for late answer! I believe, you want to search for combination of state and company type; also, there could be a search for multiple states. Please correct me if wrong. You may try the following query: ### SELECT * FROM...

MS SQL: SQL Update Query, mysql, update
mysql, update, table1: Dear Brian, Very sorry for late reply! I am putting here my understanding of the problem: Table1 has updates in it, which needs to be updated in Table2. Table2 already has related row for the record, and it has to be only an UPDATE query. You need...

MS SQL: db2 distinct query that pulls the first value from column 3, distinct combination, table values
distinct combination, table values, return values: Hi Debbie, You could get the distinct and one of the values from col3. However on what basis does a specific row for col3 get selected? Is it the first occurence of it? If that s the case is there a clustered index on the table which determines the sort...

MS SQL: Last Payment Dates, sql server, max
sql server, max, group by: Dear Alp Durmaz, You can use GROUP BY clause along with MAX SQL inbuilt function to achieve the desired result. Below is how: ######## SELECT CUSTOMERID, MAX(PAYMENT_DATE) FROM Payments GROUP BY CUSTOMERID ######## Feel free to follow-up. Thanks,...

MS SQL: about sql 2005 database, microsoft sql server, microsoft sql server 2005
microsoft sql server, microsoft sql server 2005, sql server 2005: Hi Ashish This is really good with lots of inside details.... Inside Microsoft SQL Server 2005: T-SQL Querying http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139/ref=sr_1_3?ie=UTF8&qid=1297644078&sr=8-3#_ Thanks Mohi...

MS SQL: Full table scans ignoring index, full table scan, execution plan
full table scan, execution plan, content column: Hi Bill Selection of non-clustered index depends upon the uniqueness of the data and in your case it doesn t seem to be the case. Also, I might need to look at the execution plan to come up with more accurate info. Can you please do the FULLSCAN while...

MS SQL: Group By, grouping data, select name
grouping data, select name, jd: Hi JD, please use the ROW_NUMBER function to get the same. Please run this script to get the results. CREATE TABLE #temp ( Name VARCHAR(5), State CHAR(2), Sales SMALLINT ) GO INSERT INTO #temp (Name, State, Sales) VALUES ( Mo , CA , 1500 ) INSERT...

MS SQL: Select the higest values, Highest Value, GROUP BY
Highest Value, GROUP BY, MAX: Hi Alp, My apologies for late reply! The required result can be obtained using GROUP BY clause and MAX function. Here s the sample query: ###################### SELECT MAX(DealID), CustomerID FROM Deals GROUP BY CustomerID ######################...

MS SQL: Select the higest values, sql server, query
sql server, query, max: Dear Alp, You can use GROUP BY and MAX built-in functions to achieve the required result. Here s a sample query. ############## SELECT DealID, MAX(CustomerID) as CustomerID FROM Deals GROUP BY DealID ############## Feel free to follow-up. ...

MS SQL: Access SQL question - Record with Email address, email, duplicate records
email, duplicate records: Dear Ron, There are multiple ways of achieving details of author according to email address. You can write a query with DISTINCT clause on Email Address column or can also write query using MAX on the Paper ID#. Here are simple examples: ##########################################...

MS SQL: Using DSN to access Database, connection string, dsn
connection string, dsn, access database: Hi Tyler I am not very well familiar with MFC. I am little confused here. You are refering to DSN and Connection string. And why DSN in the database. DSNs are system specific or file based. So, lets use a connection string to connect to your database...

MS SQL: How to return an integer?, TSQL, SELECT 0
TSQL, SELECT 0: Hi Alp, Sorry for very late reply... You may try the below query: ############################ IF ( SELECT COUNT(*) FROM Customers WHERE CustomerID = 3000 ) = 0 BEGIN SELECT 0 END ELSE ( SELECT CustomerID FROM Customers ...

MS SQL: Return an integer, number thanks, select name
number thanks, select name: Hi Alp There are various ways, but you can use IF EXISTS or @@ROWCOUNT to start with... SELECT Name FROM Customers WHERE CustomerID=3000 SELECT @@ROWCOUNT AS TotalCount The above query will return the actual number of rows affected. So, in this case...

MS SQL: Select Match Problem, record, multiple values
record, multiple values, tsql: Hi Alp, I think it should be better to design the table in a different way to handle such kind of information. However, here is the SQL Query for given situation. ######################## SELECT DISTINCT T1.Name FROM Members T1 INNER JOIN Members...

MS SQL: Select Match Problem, member status, 1 john
member status, 1 john, match: Hi Alp I have 2 options to resolve this... --Option 1 select t1.member, t1.Status, t2.Status from Members t1 INNER JOIN Members t2 ON t1.member = t2.member WHERE t1.Status = 1 AND t2.Status = 2 --Option 2 select member FROM ( --give me all...

MS SQL: Checking status of the JOB, set job, request source
set job, request source, sql programming: Hi Nelia I guess you are trying to find out what all is running currently. I request you to have a look at alternate approach give under and pass the Job Id... http://www.sqlnotes.info/2012/01/13/are-jobs-currently-running/#more-1194 Thanks ...

MS SQL: Select specific records, self join, where
self join, where, not in: Dear Assaf, Here you would need to use either subquery or self join. As there s only one column to join two queries or tables (member id), subquery would be the easiest one to use. with subquery: ############## select t.TransID , t.MemID , m.lname...

MS SQL: SQL Server, microsoft sql server, student responses
microsoft sql server, student responses, performance issues: Hi Priyanka How are you collecting this data and where. If you have the data in Excel including answers then you can either use Excel to derive the final report or you can export this data to Microsoft SQL Server for further analysis. It depends on your...

MS SQL: Stored Procedure, web programming language, procedure parameter
web programming language, procedure parameter, security introduction: Hi Achilles There are lots of functions/controls available in the web programming language like ASP.Net where you can get these values and then pass the same as stored procedure parameter. Otherwise your procedure is okay. Please have a look at these...

MS SQL: key, central mumbai, chapra
central mumbai, chapra, m551: Hi Sanyog I guess you want to implement referential integrity, where Plant table should only hold valid cities which exists in master table City . If this is correct, then I suggest you break you tables like this and create proper primary key and foreign...

MS SQL: Question regarding SQL, person id, string functions
person id, string functions, column names: Hi Venkat Please use UPPER . SELECT UPPER (PersonName) AS PersonName FROM Persons http://msdn.microsoft.com/en-us/library/ms180055.aspx Also have a look at other string functions, might help you in your interview. http://msdn.microsoft.com/en-us/library/ms181984.aspx...

MS SQL: SSIS package/procedure, ssis, dts
ssis, dts, csv: Hi Rana, I would think this will involve more coding inside outlook (VBA coding) to perform as mentioned. This way, it will be a VBA code to download attachment from the email to some predefined folder and then either - kicking a stored procedure (through...

MS SQL: database design and coding for Front-End Web Developer, content management system, database subject
content management system, database subject, server tutorial: Hi Jake I am really sorry for the delay. There are lots of books, links and videos to start learning SQL. I will recommend few here... Online Links http://www.w3schools.com/sql/default.asp http://learnsqlserver.in/ http://www.quackit.com/sql_server/tutorial/...

MS SQL: Regarding Restore database, crash 4, sql server 2000
crash 4, sql server 2000, recovery model: Hi Niaz Can you please let me know the following... 1. What was the last time you took the database backup of 13 GB? 2. Can you just try restoring the headers/filelist to reconfirm the issue/backup sets? 3. What was the estimated size of database before...

MS SQL: Result set is closed, sql string functions, java sql
sql string functions, java sql, sql connection: Hi Murali If you objective is to update rows in a table based on 2 columns then I suggest you perform this in database (stored procedure) instead of a java function. You can make sure of various SQL string functions to achieve the same. http://msdn.microsoft.com/en-us/library/ms181984.aspx...

MS SQL: Complex SQL Query, Self join
Self join: Dear Kristin, This is an example of a need where we want to use SELF JOIN. First find all first and last name which have I9 form and get all except those guys. This might work for you: SELECT a.FirstName, b.LastName FROM TABLENAME A LEFT JOIN...

MS SQL: Stored Procedure to enter multiple rows into a table
Hi TJ Please use following code, I create a sample table and store procedure for you as sample. Please feel free to modify as you like. IF OBJECT_ID( TestTable , U ) IS NOT NULL DROP TABLE TestTable GO IF OBJECT_ID( uspInsertRows , P ) IS NOT...

MS SQL: help with sql statement
Hi Dany, you approach is right...can you share your error, try following... UPDATE OtherTableYouhave SET ColumnName = final.Result --SELECT * --This is just to verify before Update FROM ( SELECT Table1 AS Table, SUM(a) - SUM(b) AS Result FROM table1...

MS SQL: More number of concurrent database access requests
Hi Kalyan, The problem seems to be elsewhere in how the data is fetched or stored. 10 concurrent users is extremely tiny for any DB technology. Systems are mature to scale to several hundreds/thousands concurrent based on the design and implementation....

MS SQL: combining multiple select statements for a stored procedure
Hi Tejus I guess you want to add count for all the queries, if that s true then there are multiple ways to do the same. 1. Declare a local variable and use that in every query DECLARE @cnt INT = 0 SELECT @cnt = @cnt + COUNT(1) FROM Query1 SELECT @cnt...

MS SQL: Access 2000 Query, exact requirement, structure fields
exact requirement, structure fields, call id: Hi Jeff I will help you in this. Just send me these details. 1. Table structure (fields with data type) 2. Sample records 3. Best if u can send me that MS Access file on my mail address (mohit_sme@yahoo.com) 4. The exact requirement with sample records...

MS SQL: Access db into Erwin for modeling, ms access 2000, odbc dsn
ms access 2000, odbc dsn, system dsn: Hi Jacky, You can connect to MS Access using the ODBC drivers which Erwin uses. So in the ODBC administrator , create a uSer or system DSN for the access Db. Then in Erwin choose to connect using the ODBC DSN what you created. That should work. Regards,...

MS SQL: Access Project with SQL Server, variable length, exact number
variable length, exact number, maximum limit: Hi Lawrence There is no such thing like u have to pass exact number of character when passing parameters to stored procedure. create proc test @myName varchar(20) as select * from table1 where myName = @myName Now u can run the above procedure...

MS SQL: Access SQL Query Script, query script, virtual table
query script, virtual table, access sql: Hi Dave SQL Views doesn t take parameters, and they are like virtual table. So after creating a view you can simply put a where clause to get the desired output. I will recommend using Stored Procedure for this, as they can take parameters and then...

MS SQL: Access "Unmatched" Query using more than 1 criteria, query wizard, unmatched records
query wizard, unmatched records, column names: Hi QJ, To find the rows which match use any of the following queries. Replace the table and column names with the appropriate ones. And the difference between the following three are what columns are being returned. Use the Query wizard if this looks scary....

MS SQL: Access, apper, querry
apper, querry, company names: Hi Ivan First let me understand the problem here 1. You have 2 tables (client master, commission master) 2. You want to copy data from commission master to client master based on the client name entered in client master. If this is your requirement...

MS SQL: Advanced SQL-query, soccergames, name games
soccergames, name games, sql query: Hi Johan This is quite simple. You have to join all the tables and select required fields plus select count(*) and put grouping, evn u van put order by clause. Example select PlayerID, Name, sum(gamesfield), sum(scoredfield) from table1, table2 , table3,...

MS SQL: Arabic data as parameters for executing a stored procdure, sir system, specification database
sir system, specification database, arabic characters: Hi I really don t know why you are executing a dynamic SQL statement here. I really don t see any reason for that. Your tables are fixed here and you can simply use variables in insert statement. if (some business logic if required) begin IF NOT...

MS SQL: ASCII into MySQL, column configuration, export wizard
column configuration, export wizard, time and patience: Hi Aaron Using Microsoft Import/Export Wizard under SQL Server you can easily transfer your text file to any DBMS available. 18 MB is just a small file and you can easily transfer the data and you can also specify the filter criteria while uploading or...

MS SQL: ASP default value, article names, error msg
article names, error msg, connection string: Hi rs.open select id, title from article , strconn while not rs.eof response.write a target=_blank href= detail.asp?id= & rs( id ) & & rs( title ) & /a br rs.movenext wend rs.close The above code give u a link to your articles and...

MS SQL: Atribute definition, storage size, precision level
storage size, precision level, numeric data: I am not sure what you mean by length for the numeric data. If you are trying to see how much it can store, then it s 10^38 +1 through 10^38 - 1. If you are trying to change the storage byte size, then you need to change the precision level and below would...

MS SQL: Auto Fill Form in Access 97, strsql, database option
strsql, database option, dim rs: Hi Joanne Thats easy. 1. Create a combobox and in the Load event of the form fill the combo with A/c, first and last name. 2. Now write the above code in validate event of combo box and fill the text box with respect to selected a/c. If you don...

MS SQL: Autonumber data type, ms office 97, ms office 2000
ms office 97, ms office 2000, autonumber field: Hi Pauline This is strange. Now please note if you have done any of these previously. 1. Make the data type of AUTONUMBER field and then inserted some data manually. 2. Try to find existing duplicate values for the field. 3. Try to make a new table...

MS SQL: alternative to cursor, manoj, cursors
manoj, cursors, thanks in advance: Hi Rick, You could skip using cursors, by creating temp tables like #table and ##table. Then you could traverse through the selected rows as though you would with a cursor. I looked around for specific examples but unfortunately could not fine one....

MS SQL: automatic importing data into database searched automatically from different databases, kind suggestion, technique software
kind suggestion, technique software, book publishers: Hi Ok Man again the job is done. Yes, u can use mySQL with PHP. See HTML is static so u have to do HTML coding with some server side scripting. Thats is why I suggested ASP (Active Server Pages). But the combination of mySQL and PHP is like SQL and ASP...

MS SQL: BCP, bcps, dts
bcps, dts: Yes of course possible, but this is too strange.. You need to do 2 BCPs for this purpose The first one is a bcp out statement to store the contents of the first table to a specific file and the second one will do a bcp in operation to push the contentest...

MS SQL: Best way to create a new database, resource requirement, data music
resource requirement, data music, software players: Hi Reginald If you are just concerned about performance then I will recommend creating 5 different fields for each keyword, because = comparison is much faster than like or charindex. But as you said that this is something related to website search...

MS SQL: Binary Data, microsoft sql server 2000, sql server 2000
microsoft sql server 2000, sql server 2000, microsoft sql server: Hi Maitri, Here s the explaination from Books Online Using Binary Data The binary and varbinary data types store strings of bits. Although character data is interpreted based on the Microsoft® SQL Server™ 2000 code page, binary and varbinary data is...

MS SQL: BLOB Fields in MSSQL, blob fields, csv format
blob fields, csv format, server text: Hi Dieter, I would advise, you to save the excel file in a csv format or a tab delimited text file and then do an export. Excel creates some known issues (by design) based on the data. However with a text file, you always get what you expect. Regards,...

MS SQL: bcp program at command prompt, sql server 2000, developer edition
sql server 2000, developer edition, sidenote: Hi, Check whether the directory exists or not. The error prsently indicates the directory does not exist. Also as a sidenote, it looks like you arebacking up your database. Why don t you use the Backup wizard to backup the complete DB rather than bcp ?...

MS SQL: bulk insert with updated file, bulk insert, sqlserver
bulk insert, sqlserver: By default there is no option if you are using the BULK INSERT Statement. what you can do is to create a new lookup table first and then from that table you can insert the new data using NOT EXISTS ... Option2 ------- Truncate the old table and populate...

MS SQL: Code move to next field., pop calendar, gotfocus event
pop calendar, gotfocus event, design mode: Hi Ivan, Click on the Form field, where you want this to happen, in Design Mode. Click Right mouse and choose build event (it s basically you are adding code to an event). In the events drop down, choose the gotfocus event, for and assign the now() value...

MS SQL: Complex SQL, query wizard, estimated sales
query wizard, estimated sales, sql statements: Hi Sudha, You could use the query wizard to do this or else your SQL statement would be : select * from Actual1 as A , tblForecast as F where a.customer = F.customer That will show all the columns in both the tables and if you need to see specific...

MS SQL: Connect a web-site with a database, nayyar, mohit
nayyar, mohit, ms access: Hi Thodoris Sorry for the late response. Yes this is very much possible and u can put the content into the database directly. But how u are planning to get the content, like how do u check that what other person is going through. Its u have figured...

MS SQL: Convert Txt file, sign ship, ship id
sign ship, ship id, column headings: Hi This is possible. You should use BULK Insert for this and all this be over in few minutes. BULK INSERT DATABASE.DBO.TABLENAME FROM c:FileName.txt WITH ( FIELDTERMINATOR = , ROWTERMINATOR = | ) ...

MS SQL: Create View, ms sql server, sql server 2005
ms sql server, sql server 2005, ms sql server 2005: Dear Jose Luis, If possible try to use a temporary table and store data from the first query to it and take the data where u want the same. Other way depending upon which front end you are using, you can store the id from first select query to any object...

MS SQL: Creating dynamic website?, creating web sites, dynamic sites
creating web sites, dynamic sites, sql databases: Hi Thanks for the question. I am working in Microsoft Tech. (ASP, SQL) for last 4 years and i find it very easy to learn, reliable, cheap, and easily available development support for the tech. Even PHP and mySQL combination is perfect for small websites....

MS SQL: Crostab query, ms access database, ms sql server
ms access database, ms sql server, exact output: Hi Julia ok, then don t use IsNull function and along with status in where clause you can put date criteria and i think when you put ? in front of date criteria then Access will ask you for date. select * from table1 where mydate = ? Thanks...

MS SQL: calling stored procedure, nayyar, select count
nayyar, select count, result sets: Hi this will help u ************************************ Do While myReader.Read() Add code here to loop through the records of the current result set End While Switches to the next result set, or returns False if all result...

MS SQL: What to chose, ms access 2000, good user interface
ms access 2000, good user interface, interface features: Hi SAM My name is Mohit and i think by mistake u have forwared me this question. But, i can answer this question. You can directly go for MS ACCESS 2000. You just have 1000 students and even access can support upto thousands for rows and some very...

MS SQL: converting triggers from sysbase to SQL2005, rollback transaction, sysbase
rollback transaction, sysbase, example answer: Hi Chetan Remove the ROLLBACK TRANSACTION from the trigger. Here I have a working script based on your requirement, run this script and then execute procedure usp_testing_insert and check if you have any records in testing table. CREATE TABLE testing...

MS SQL: count records, well thanks
well thanks: Hi Samir There are many ways to do that. Let say if you have any identity column than just get the max(col_name), but just make sure that you don t delete any row from this table. Otherwise if you have clustered index on table then you can query sysIndexes...

MS SQL: create a sql script, dts package, sql script
dts package, sql script, osql command: Hi Pete, You could use osql and it comes with an option of getting the results in a text file. You could call your DTS from osql, schedule the osql command from OS schedules tasks or create a SQL job (use xp_cmdshell to call). Regards, -Mano...

MS SQL: created user after backup and restore DB, sql server books, microsoft sql server
sql server books, microsoft sql server, change users: Hi Setsiri This problem is called Orphaned User problem , where when you restore the backup from one machine to another machine then no users will be copied but there will be entries available in the copied database. Now you can run sp_change_users_login...

MS SQL: No to cursors?, sql statements, scenerios
sql statements, scenerios, main objective: Hi Rick The main objective of using cursor is to perform some sort of calculation on indiviual rows, where you cannot use T-SQL batch. So, in some scenerios you can make use of nested queries but still that don t helped much. So, if you have to perform...

MS SQL: Data Flow Diagram and Entity Relationship, entity relationship diagram, production management department
entity relationship diagram, production management department, data flow diagram: Hi Lindsey See, just read these details again and then think how the system will look like. Now if you need a familiar application then think about any banking branch where people come and do so many activities like deposit/withdrawl etc. Now this...

MS SQL: Data Mapping from Oracle to MS SQL Server 7.0, ms sql db, heterogeneous data sources
ms sql db, heterogeneous data sources, ms sql server: Hi Joe, I can answer the question from SQL Server s side. In SQL server you can define something called Linked Server. This will allow you to link to heterogeneous data sources, like Oracle, etc. And when you establish the link between your SQL server to...

MS SQL: Data Mapping from Oracle to MS SQL Server 7.0, sql server database, ms sql db
sql server database, ms sql db, ms sql server: Hi Joe Thanks for the question. There could be more than 1 solution to this problem: 1. Create a Linked Server at Oracle end for MS SQL Server AND upon any modification in the Oracle database fire a trigger for updations in MS SQL Server database...

MS SQL: Database Backups, sql server agent, network folder
sql server agent, network folder, vendor documentation: Hi Santosh Yes, backup to a network folder is possible but yr SQL Server Agent Account (Using which u start SQL Agent) must have rights on the network machine, and u can do so only by using domain account. For the tape backup issue u have to check the...

MS SQL: Database Developement, software piracy policy, ms sql server
software piracy policy, ms sql server, enterprise level applications: Hi Charles Thanks for the question. First, keep in mind these two things 1. MS SQL Server is an RDBMS (database and NOT Operating system). It is capable of handling large enterprise level applications. It costs u well. Keep in mind the cost factor...

MS SQL: Database Query, mitral valve surgery, dr prasad
mitral valve surgery, dr prasad, surgery name: Hi Tibu, Firstly if you are storing multiple doctor names in a single column, you are doing a big mistake. Store them in seperate columns, like primary surgeon, sec surg,etc. Then to get the number of operations for a surgeon, do this. Select surg_name,...

MS SQL: Database Query, mitral valve surgery, dr prasad
mitral valve surgery, dr prasad, surgery name: Hi Tibu Answer to second question is very easy you just need to group your Pon_Date field on month basis and that will give you the output. Select month (pon_date), year(pon_date), count(1) as total_patients from pre_Operation_note group by month...

MS SQL: Database Recovery, sql server 2000, file db
sql server 2000, file db, database recovery: Hello, Check the mdf and the ldf files, if they exist anywhere on the harddisk. If they exist, there are some remote chances of retrieving else there does not seem to be any way. Also check your recycle bin to see if those files exist. If you have those,...

MS SQL: Database Report Generators, report generators, lotus 123
report generators, lotus 123, generator programs: Hi Bruce, If you export all your data into a database like MSSQL Server or MYSQL (free) from your Lotus 123 Spreadsheets, then you have lot of reporting options which can report from a database. If you happen to use MSSQL Server, then there are reporting...

MS SQL: Database Restore - SQL2000, single user mode, master db
single user mode, master db, database statement: Hi Allison, I assume you are trying to restore the master DB. If that s the case, then Start QL Server in single-user mode. Execute the RESTORE DATABASE statement to restore the master database backup, specifying: The backup device from where the...

MS SQL: Database Troubleshooting, sql databases, sp who2
sql databases, sp who2, cpu status: Hi Santosh Thanks for the question. There could be more than 1 reason for this problem. So have to take some steps in the given order to find out the problem. 1. Check the time when this happens (particular days and time). 2. When providing some...

MS SQL: DateTime in database, ms sql db, datetime
ms sql db, datetime, constraint: Hi Vitaliy You need to update that field using your update statement or you can write a trigger to do the same. In case of add you can make use of DEFAULT Constraint but in case of modifying an existing row you have to do trigger solution. Thanks...

MS SQL: DB Compare script, vb6 program, expert 3
vb6 program, expert 3, development computer: Hi I think you can directly make use of INFORMATION_SCHEMA.Columns view and make a list of all required changes. You will get more columns with complete columns details on DEV db and then you can also generate a script to add those columns to PRODUCTION...

MS SQL: Deadlock Problem, deadlock problem, isolation level
deadlock problem, isolation level, business requirement: hi There are many solutions to this problem. But you have to see the business requirement and I can suggest you some standard solutions. 1. Access objects in the same order. 2. Avoid user interaction in transactions. 3. Keep transactions short and...

MS SQL: Determining the last usage (DML) of a SQL Server Database, sql server database, sql server 2000
sql server database, sql server 2000, master db: Hi Andy, You are looking at the create dates of those objects. That will not help you since objects could have been created long back and every day, the Db might be actively used in terms of adding /modifying data. That would not be reflected. So your...

MS SQL: Distinct date time excluding seconds, table id, date time
table id, date time, doubts: Dear Prashanth Kumar G., I think converting this date to smalldatetime datatype (ex: cast(datecolumn as smalldatetime))while query would serve the purpose. Please with that first, otherwise grouping by convert(char(16), datecolumn, 112) should help too....

MS SQL: Downloading data from website to SQL server database, ms sql server 2000, complete web service
ms sql server 2000, complete web service, xml csv: Hi Rajani Thats a great news. Now SSIS can pull data from web services as well, but as you must be knowing that this functionality expects complete web service standards (method calling etc.) And we just have a website, so this is what I will do. ...

MS SQL: 'DROP TABLE', ms access database, object variables
ms access database, object variables, adox: Hi Martin Happy New Year and I am really very sorry for late reply, but I was not in the country. I think you can make use of ADOX for schema related operations in MS Access system with Visual Basic. You Can modify this code accordingly. *******************************************...

MS SQL: DTS TECHNOLGY, ms sql server, sql server 2000
ms sql server, sql server 2000, datawarehouse: Hi Jorge, DTS = Data Transaformation Services in MS SQL Server. It is basically used to extract data from various data sources, transform the data into desired format (example, you might have a 2 systems where phone numbers are stored. In one of them it...

MS SQL: Duplications!, doe john, lasry
doe john, lasry, database issue: Hi Assaf Thanks for the question. Here is ur answer in two parts. --------------------------------------- To check all duplicate names select lastname, firstname, count(*) as Total_Duplicates from clients group by lastname, firstname having count(*)...

MS SQL: data encryption and decryption, encryption and decryption, password age
encryption and decryption, password age, data encryption: Hi Gary See, there is not proper method available as in-built function for end users to encrypt the data. So, most of us use some user made encyrption function to encrypt and descrypt data. I use to do all the encryption and decryption on my front end...

MS SQL: data encrytpion and decryption, ascii value, encrytpion
ascii value, encrytpion, encryption algorithm: Hi Gary, In SQL Server you do not have the provision of encrypting a column. However you could have your own encryption algorithm , encrypt the data at the application level and then store it in the column. For example, all the characters in the password...

MS SQL: database, ms sql server, microsoft sql server
ms sql server, microsoft sql server, server thanks: Hi Saroj Both are same, Microsoft SQL Server. You can learn SQL online using any of these links. But I will recommend buying a Learn SQL Server in 24 Hours / 21 Days type book and then go ahead with more advance learning. http://www.google.com/search?hl=en&rls=com.microsoft%3Aen-us&q=learn+sql+server...

MS SQL: databases, sql development, datawarehousing
sql development, datawarehousing, database world: Hi Jai See, you are talking about two things here. You can do administration in warehousing as well. But in general when we talk about Database Administration then it just means talking care of your database in all respect other than T-SQL development....

MS SQL: databases, sql development, datawarehousing
sql development, datawarehousing, database world: Hi Jai See, you are talking about two things here. You can do administration in warehousing as well. But in general when we talk about Database Administration then it just means talking care of your database in all respect other than T-SQL development....

MS SQL: date, microsoft sql server 2000, sql server 2000
microsoft sql server 2000, sql server 2000, microsoft sql server: Hi Michelle Yes, this is with SQL Server only, it will automatically insert 1900-01-01 00:00:00 instead of NULL for date field. You have to take care of this at front-end if the value is empty then take some action based on business requirement. ...

MS SQL: decryption of stored procedure
Hi, Once a Stored Procedure OR view is created WITH ENCRYPTION, then there is no way you could decrypt it back, for even admin purpose. So if you need to change the Stored Proc, you need to drop and recreate with the changes once again. Regards, -Mano...

MS SQL: design of a convertor, sql oracle, oracle books
sql oracle, oracle books, semantic value: Hi Meera I can def. help u. But I don t know Oracle at all. But the difference between T-SQL (SQL Server) and P-SQL (Oracle) is not huge. So we can work on that. Better if you go through any book on SQL and Oracle. Books like SQL in 24 hours etc. will...

MS SQL: Are there any difference between SQL Server 7 and SQL Server 2000 regarding set ansi_padding?, sql server 2000, database settings
sql server 2000, database settings, sql server 7: Its better to check the database settings for each server. And there are major changes with respect to SQL Server 6.5 and 2000. Please give me two days time, so that i can forward u the complete document. Kindly give me your email address to forward the...

MS SQL: Error trapping/ or error translation, sql server 2005, error numbers
sql server 2005, error numbers, primary key: All the errors thrown at you have error numbers too. Find the error code of this message on Books Online and in Access use error handling to trap this error and when the error happens translate the error to the right message you want. Regards, -Mano...

MS SQL: Field order in INDEX creation, index creation, sql books
index creation, sql books, query optimizer: Hi Frans You have just mentioned 30 Million rows, but not the row size. See in any case, 30 million per table is not good, why don t you split the data into multiple table and then work with views. And if you are doing extensive insert/update on this...

MS SQL: Fields order in index creation, index creation, query analyzer
index creation, query analyzer, sql 2000: Hi Frans, Yes, in the earlier versions of SQL Server that had an impact in how the query analyzer optimally handled it, for your select statements. But in SQL 2000 it does not matter, but I would still follow the old rule, to be consistent. Regards,...

MS SQL: Filter by month & making an excluding view, sql server management, microsoft sql server
sql server management, microsoft sql server, incorrect syntax: Hi Dennis, For your first question, you could do this select * from tablename where datepart(mm,datecolumnname) in (3,4,6,11) will give you rows which are of months March, April,June and November. As for your second question, you could do this...

MS SQL: Function Help, rajiv kumar, msaccess
rajiv kumar, msaccess, ms sql: Dear Raji, then in your previous queries, I have already mentioned the same, anyways, its as under: 1. year start date: ### select cast(convert(char(4), getdate(), 112)+ 0401 as datetime) ### and here getdate can be replaced by any date you want The...

MS SQL: Access db into Erwin for modeling, blank database, mdb
MS SQL: Access db into Erwin for modeling, blank database, mdb

MS SQL: Arabic data as parameters for executing a stored procdure, character string, exec
MS SQL: Arabic data as parameters for executing a stored procdure, character string, exec

MS SQL: count records, index id, object id
MS SQL: count records, index id, object id, dmv

MS SQL: Distinct date time excluding seconds
MS SQL: Distinct date time excluding seconds

MS SQL: decryption of stored procedure, google
MS SQL: decryption of stored procedure, google

MS SQL: formatting MS SQL timestamp column, dynamic cursor, timestamp column
MS SQL: formatting MS SQL timestamp column, dynamic cursor, timestamp column, poor candidate

MS SQL: about generating query, varchar, subroutines
MS SQL: about generating query, varchar, subroutines, wildcards

MS SQL: MSSQL Backup, dba, bak file
MS SQL: MSSQL Backup, dba, bak file

MS SQL: Paging using MS SQL Query, row numbers, drop column
MS SQL: Paging using MS SQL Query, row numbers, drop column, intelligent software

MS SQL: Recognizing NULL values, boolean data type, store collections
MS SQL: Recognizing NULL values, boolean data type, store collections, maximum efficiency

MS SQL: Saving image in SQL Server using VB6, images
MS SQL: Saving image in SQL Server using VB6, images

MS SQL: Searching Huge Database, ce3, ms sql
MS SQL: Searching Huge Database, ce3, ms sql, syntex

MS SQL: Select one row from multiple from a mapped table!
MS SQL: Select one row from multiple from a mapped table!

MS SQL: Setting the identity property using a query, enterprise manager, sql server management
MS SQL: Setting the identity property using a query, enterprise manager, sql server management, ms sql server

MS SQL: SQL Database Restore
MS SQL: SQL Database Restore

MS SQL: SQL database table data last modified date, max column, column name
MS SQL: SQL database table data last modified date, max column, column name, time changes

MS SQL: SQL Query
MS SQL: SQL Query

MS SQL: SQL query question - joining two tables
MS SQL: SQL query question - joining two tables

MS SQL: SQL Report, text test, test text
MS SQL: SQL Report, text test, test text, ms sql

MS SQL: SQL server maintenance, maintenance activity, production server
MS SQL: SQL server maintenance, maintenance activity, production server

MS SQL: formatting MS SQL timestamp column, sql timestamp, ms sql server
sql timestamp, ms sql server, timestamp column: Hi Chris, Timestamp is used to indicate the sequence of SQL Server activity on a row, represented as an increasing number in a binary format. As a row is modified in a table, the timestamp is updated with the current database timestamp value obtained from...

MS SQL: GROUP BY with an associative table, subject id, book id
subject id, book id, preception: Hi Ali Yes, you are right. But its not returning wrong information but the preception is wrong. Try to make use of Distinct. So, either u can get the MainSubject, No_of_Books or books under each sub-subject. select s.subject_title, count(sb.book_id)...

MS SQL: Groups in Ms-Sql, sql server users, sql server computer
sql server users, sql server computer, sql users: Hi Pradeep I am assuming that you are familiar with Microsoft Windows logins and understand SQL Server windows authentication. If you don t then I request you to go through SQL Server Books Online and proceed. http://msdn2.microsoft.com/en-us/library/ms189751.aspx...

MS SQL: about generating query, charindex, question sir
charindex, question sir, three tables: Hi, In this case, the design needs to be changed. You cannot store multiple values in the same row. That defies the rules of database design. But if you stil want to do this, then you would have to pasrs through the string using charindex and substring...

MS SQL: Help with Tricky Query, time fields, complex filter
time fields, complex filter, hi tim: Hi Tim I am not very sure about the results of this query or it may fail after some time becuase u didn t put any JOIN on the key values in both tables and just used the start and end time to get the data. The better approach is put a key value join...

MS SQL: Help writing my query, parameter length, mohit
parameter length, mohit, target: Hi Joey Just check the @subject parameter length. This must be of length 1 that is why it is taking the first character. And if it is not then check the internals of @subject parameter (parsing). Or the target length for the field in which u r inserting...

MS SQL: Hi, I have two tables:table..., corresponding elements, nayyar
corresponding elements, nayyar, set id: Hi Yulia This will help you, i have used some assumptions. Just check this and reply me whether this will be useful or not. ID 1 2 3 4 5 Here u have to count the number of records that has been deleted Example 1: u deleted id no 3 (just 1...

MS SQL: help with a query, comma separated values, column c
comma separated values, column c, one two three four five: Hi Greg You can update the 3rd column (column_c) with this query, I am assuming that you have comma separated values in both a and b columns. UPDATE TABLE_NAME SET column_c = column_a + , + column_b Thanks Mohit http://mohitnayyar.blogspot.com/...

MS SQL: help with query, existing design, select count
existing design, select count, primary key: Hi Richard, As part of a database and table design, you always need to have something unique defined between rows, like a primary key. With that you will know what to set it in your filter to exclude the new record. But if want to use the existing design,...

MS SQL: Indexing Views?, index views, volumne
index views, volumne, frequent updates: Hi Richard, If there are not many indexes, yes they could remain. Otherwise it would be better you drop them and recreate after completing the data load. If you have clustered index, then rearrangement of data pages will still happen if you drop the index....

MS SQL: Inner Join, exchange code, inner join
exchange code, inner join, alq: Hi Ankit You are making use of INNER JOIN in both queries. In the first query you are using ANSI syntax, and you other query is Microsoft syntax. ANSI is always better and Microsoft recommends this. Please read this carefully, this is some extract from...

MS SQL: Inner join is giving me more rows than I expect, inner join, null values
inner join, null values, two tables: Hi Good question... Now leave everything and consider this scenario... table1 with col1 have 3 rows with number 1,2,3 table2 with col1 have 9 rows with number 1,1,1,2,2,2,3,3,3 So if I do the inner join between these two tables on col1 then what...

MS SQL: Insert query, syntax error or access violation, awt event
syntax error or access violation, awt event, java awt: Hi Peter Just remember the basics 1. While inserting new rows in any DBMS. INSERT INTO TABLENAME (FIELD1, FIELD2) VALUES (VALUE1, VALUE2) 2. When need to modify the existing data then UPDATE TABLENAME SET FIELD1=NEWVALUE1, FIELD2=NEWVALUE2 I...

MS SQL: Insert and Selectin same SP, insert into table, store names
insert into table, store names, select statement: Hi Dave Sorry for late reply, but I was not in the country. Your question is bit confusing, but why don t you try to make joins and get the store information and use that select statement as the base for insert. insert into table (field1, field2)...

MS SQL: Installation of MS SQL 7 to Windows 2003 server, sql 7, sql server 7
sql 7, sql server 7, ms sql: I apologize for the delay in getting back to you... I didn t get a notice that I had a question pending until today (sigh) No, MS SQL 7 is not supported on Windows 2003. http://support.microsoft.com/?kbid=810391 If you try to install SQL Server 7.0...

MS SQL: init to create databases, menuitem, local group
menuitem, local group, default location: Dear Willy, As you have already installed sql server. Then go to the server name and right click it to get new database. Here you will be asked for the name of the database and the database files location. I prefer putting database at default location, if...

MS SQL: Join Statement, lasry, nayyar
lasry, nayyar, sql statement: Hi Its simple. Just like normal joins and put the required LEFT join in the condition and additional LEFT. BUT u have to be careful because ultimately u have put in an INNER JOIN so, no. of rows are restricted. example select fields from table1 a...

MS SQL: Joins vs subselects, sql server 2000, code string
sql server 2000, code string, distinct values: Hello Milin, The second query is the way to go. Subqueries are more expensive. Also if you look at both queries and imagine yourself to be the query optimizer, the second one looks more less iterations to be run than the first one. Also using a subselect...

MS SQL: Joins vs subselects, sql server 2000, code string
sql server 2000, code string, distinct values: Hi Milin No questions. The join query (second query) will do much better. Ok you must have heard of less join conditions, but it doesn t mean that you should remove joins and concat the final fields. Joins are always better than the subqueries, unless...

MS SQL: List of Categories, desired results, treeview
desired results, treeview, infinite number: Dear Alp Durmaz, Here you need to take one while loop and move it for all the records in this table and thus would with the help of one more select query able to produce desired results. Please find the first level parents and then put that into one temporary...

MS SQL: Lock:Released events problem, sql server release, customer table
sql server release, customer table, key lock: Dear Geza Thats a real good question. But as of my knowledge, SQL Server doesn t release the locks for the transaction until you commit or rollback the tran. The best illustration of this issue is run a tran update few rows in a tran without commit...

MS SQL: Microsoft Access and SQL Server, sql enterprise manager, app development
sql enterprise manager, app development, combo box: Hi Ron, SQL Server is a pure Database server unlike Access which includes additional components to create forms/controls,etc. SO in SQL Server you cannot do like creating forms/controls etc, but you can design a very robust, scalable DB server, unlike...

MS SQL: Last Modified, file group, manoj
file group, manoj, dml: Charles, A DDL or a DML? I assume you are referring to DML (since you say add/update and delete). If that s the case, then you have to have to design the DB to accomodate that (like having a modified date and modified by) in all the tables and populating...

MS SQL: MS Access d/b Query question, todays entries, ms access
todays entries, ms access, queries: Hi Sorry, but the requirement is not very clear. I will be really thankful if u can send me the question again with expected output etc. I think u just need to get the result in two different resultsets, one for todays entries and the another one for...

MS SQL: MS Access, acer ferrari 3400 laptop, plent
acer ferrari 3400 laptop, plent, weird problem: Hi Boet, This is a very weird problem I have come across. The only thing which I would advise a this stage is try to get the latest Office updates. Hopefully there might be a fix on this issue. Otherwise tr to repair your access. But please do backup all...

MS SQL: MS SQL 2005 How to merge databases, sql server 2000, sql server 2005
sql server 2000, sql server 2005, export wizard: Merging of tables is simple, but just make sure that you have same column data types. And after that comparison, try to import the data from table1 to table2 by mapping the columns. And you are done!. Now you can achieve this in number of ways like using...

MS SQL: MS-SQL dsn based cennection, microsoft ole db provider, sql server driver
microsoft ole db provider, sql server driver, odbc sql: Hi Rajpreet Just add ur IIS IUSR_MachineName user into SQL Server and this will solve ur problem. But the best way is to create a sql server user and assign him all required rights to the database and then use connecting string with this user authentication...

MS SQL: MS SQL Query Problem, ms sql server, ms sql server 2005
ms sql server, ms sql server 2005, sql server 2005: Dear Ram, The where clauses in the sub selects will narrow down the time required drastically. Also you can use indexing on the column on which you are using where . Sorry, but this is the only thing coming in my mind. Try it out and you will be able to...

MS SQL: MS SQL Server, sql server database, ms sql server
sql server database, ms sql server, sql commands: Hi there RULE OF THUMB Whenever executing queries that don t return data (INSERT, UPDATE, DELETE), use them only through connection object Execute metehod. Use Recordset open method for queries that return data for front-end processing (SELECT). ...

MS SQL: MS SQL, ms sql server, sql server 7
ms sql server, sql server 7, sql software: Hi Jennifer MS SQL Server is an RDBMS program that you can install on MS Windows OS. 1. Install OS (MS Windows 98, 2000, XP) 2. Install MS SQL Server (7.0, 2000) So, you can access sql server like any other program (e.g. MS Word). But SQL Server...

MS SQL: MSSQL Backup, file splitters, backup file
file splitters, backup file, server enterprise: Hi Vince, SQL server as itself does not provide you a way to split the backup across cds. You need to take the backup file, split it using one of the several file splitters and then copy them to disk. If you had thought of this when you designed the...

MS SQL: MSSQL Direct Retrieve Field Value, syscolumns, sysobjects
syscolumns, sysobjects, ado recordset: Hi Michael Thats a preety good question. See, i haven t tried that and still don t know about retrieving columns values without specifying column names. But on the front end u can use the ADO Recordset Collection to get the same. Like u can write ...

MS SQL: MSSQL query logs, third party tools, sql 2000
third party tools, sql 2000, sql database: Hi This is very easy, If u have the access for SQL Server. The tool is MS Profiler, that comes with SQL Server and u must be having it. 1. Start Profiler 2. Make a connection to ur SQL Server 3. Now select some columns (please refer BOL or choose...

MS SQL: MSSQL Server 2005, microsoft ssis, microsoft sql server
microsoft ssis, microsoft sql server, microsoft sql server 2005: Rajiv, SSIS is enterprise class ETL toolset with SQL Server 2005. So if you have SQL Server 2005, then you already have SSIS. You can start development using Business Intelligence studio for your SSIS package. http://msdn2.microsoft.com/en-us/library/ms141026.aspx...

MS SQL: MSSQL Server 2005, csv format, oracle data
csv format, oracle data, sql server tables: Hi Rajiv, Please use SQL Server Integration Services to move data from oracle to SQL Server 2005. In the earlier version it was known as DTS. The other method would be to migrate your oracle data to a csv format. Then use the bcp utility in SQL Server...

MS SQL: MSSQL, mdf file, database property
mdf file, database property, db one: Hi Paul, In your database property, on Enterprise Manager (when you click properties for a DB using right mouse), under the data files tab, there is a setting which allows for automatic growth. In that section, you would have a file growth by 10% (as default)....

MS SQL: MSSQL7 Re installing, msdb database, dbs
msdb database, dbs, corruption: Hi Paul, Replacing files will not be an option, to correct the seeming corruption. You may have to uninstall and then reinstall SQL Server to be safe. As for your existing databases, you need to back it up. Also backup your msdb database which wil have...

MS SQL: MSSQL7 Server fail to start, database manager program, mssql server
database manager program, mssql server, server service: Hi Rex, To detach and reattach it somewhere, you would need to have the MSSQL Server service up and running. And the DB needs to be accessible and not in a suspect (corrupt) mode. Otherwise you alternate bet would be if you have any backups, pull them...

MS SQL: MsGetVersion, sql server configuration, virus issue
sql server configuration, virus issue, ms sql server: Hi Gary Frankly, I have never faced this kind of problem and Microsoft STRONGLY recommends that we should not play with registry settings. See if you have re-install your OS then there is no point in removing registry entries. And personally I have worked...

MS SQL: MULTIPLE database TABLE copy/append, microsoft dts, puny brain
microsoft dts, puny brain, base structures: Hi Scott There are so many solutions to this issue. 1. You can make use of Microsoft DTS to transfer data between servers/databases. 2. You can make use of BCP/Bulk-Copy to do the same. 3. Even replication can work well in this scenario. 4. Even Log-Shipping...

MS SQL: Multiple criteria query, table queries, qbe grid
table queries, qbe grid, winter images: H Gavin, You would need to store the keywords in a seperate tble and link it to the main table which has the images through a common identifying column. Then in your query you would need to join the two tables. Look at Joins in Books Online. There are...

MS SQL: MySql merge?, microsoft sql server, usernames and passwords
microsoft sql server, usernames and passwords, rdbms products: Hi Jason Sorry, i don t know much about MySQL. I am into Microsoft SQL Server only. But i am sure that we can implement this functionality in MySQL server (single user for all databases). I think all RDBMS products allow this. Regards Mohit Nayyar ...

MS SQL: ms access, query language sql, sql server database
query language sql, sql server database, odbc data source: Hi Manisha, What is a data source? A data source is a source of data and the connection information needed to access that data. Examples of data sources are Microsoft Access, Microsoft SQL Server, Oracle RDBMS, a spreadsheet, and a text file. Examples...

MS SQL: ms sql convert varchar to TIME, nayyar, time format
nayyar, time format, actual time: Hi Dan I have solved your problem in this example. Please convert the same in your query declare @t varchar(40) set @t = 934 set @t = replace(@t, right(@t,2), : + right(@t,2)) select @t -- Looks like time set @t = convert(varchar(5), convert(datetime,...

MS SQL: mssql, current date
current date: Hi Suresh, Not sure whether you are looking at getting the current date. If yes then select getdate() If you want to extract date from a datetime format, then select convert(varchar(10), getdate(),110) . You can change 110 and getdate() to any dates...

MS SQL: Named Database Instance, database instance, server thanks
database instance, server thanks, computer name: Hi You must be having a computer name like mohit , pc1 etc. Now when you install SQL Server on that computer under default settings first time it becomes the default instance. Now if you want to install one more instance of SQL Server on same computer...

MS SQL: Need Urgent Help, approprite, aspx files
approprite, aspx files, question sir: Dear Ashish, Yes, you are right! This can help with changing default database. And the first statement can be run without respect to the database connected. Put the database as default with is your target. =================================================...

MS SQL: Need Urgent Help, sql server management, sql server error
sql server management, sql server error, microsoft sql server: Dear Ashish, According to the article on the page: http://practicalsqlserver.blogspot.com/2005/08/after-restore-user-account-does-not.html , you should login the database with sa userid and approprite password and then should try to reset the password for...

MS SQL: Nested Subquery Optimization, medium values, movie actors
medium values, movie actors, anshu: Hi Jason This is not the best but working.......please test SET NOCOUNT ON create table #actors (intID int, FirstName varchar(10), LastName varchar(10)) create table #Actors_Medium (actorID int, mediumID int) INSERT INTO #actors VALUES (1, ...

MS SQL: Nested select with like, address values, companyname
address values, companyname: Hi If I understood correctly then you need to find details of one column in another column of the same table. In this example of Northwind database, we are searching CustomerID in CompanyName of Customers table. USE Northwind GO SELECT * FROM Customers...

MS SQL: Nested select, microsoft ole db provider, microsoft access driver
microsoft ole db provider, microsoft access driver, odbc microsoft access driver: Hi Per-Otto Thanks for the question. Here i can see a very basic problem in the query. Always remember these point when executing subqueries: 1. You have to select a single field in the subquery. e.g. select * from Table1 where myField in (select...

MS SQL: Normalize, foreign key, group table
foreign key, group table, mapping tables: Dear Rohit, You may consider a design with master tables for almost everything and then mapping tables to just map their id values. Thus, it will have SC table with only one row per sc and sc_code being the primary column. Then Group table with group_id...

MS SQL: NULL values in MS SQL server, sql server 2000, ms sql server
sql server 2000, ms sql server, sql 2000: Hi Rami, Every column in SQL 2000 has a property which defines it is nullable or not. If it is nullable it allows null. Now how to recognise whether the data is null or not is by using IS [ NOT ] NULL . Also there is a system table syscolumns which you...

MS SQL: queries, accommodation details, renting a room
accommodation details, renting a room, staff table: Hi See these are preety basic level queries, so I will suggest you to go through any basic SQL course. I am sure that you can learn all these things in less than 2 days. Please send me the filter criteria to find out the UNPAID invoices, so that I can...

MS SQL: normalizing a database, master category, nayyar
master category, nayyar, disciplinary hearing: Hi Perry This might help you. Student Info Student_ID All other details about the student Leaves Leave_ID Student_id leaveDate leaveTYPE - put it in general master Taken(Y or N) Promotions PromotionID Student_ID date promotiontype...

MS SQL: ODBC, sql server client, application programming interface
sql server client, application programming interface, sql server books: Hi Adrien See this is a kind of topic where you can spend at least 1-3 days just studying the system. So I will recommend you to search the google.com for this. But here is the basic information about ODBC from Microsoft SQL Server Books Online. ****************************************...

MS SQL: Outlook Contacts, comma separated values, comma delimited
comma separated values, comma delimited, csv: Dear Steve, go to outlook and you will find export in file menu, use that to export the seleted type of content (named as contacts or addressbook), this would surely allow you to export your contacts to .csv (comma separated values) file and this format is...

MS SQL: open exclusive, dear sirs, rollback
dear sirs, rollback, romeo: Hi Romeo, Yes, you could do this: select * from table (tablockx) This will hold the table till you read .. Key here is specifying tablockx and you could put this in a begin transaction and specify rollback or commit transaction only when complete....

MS SQL: opening connection on server that's local fails, sql server name, server ip address
sql server name, server ip address, sql connection: Hi Rick This is strange. Basically it is using local named pipes to make a connection on the same server as application. And your SQL server is not responding to named pipes. Now I will suggest you to make a config. using SQL Server Network Utility (Client...

MS SQL: Paging with MS SQL Query, sql query, ms sql
sql query, ms sql, page error: Regarding the first part refer the following link http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspx for the second part, i wonder about the feasibility of this technique, i am still in confusion, How will you trat in case there is a Page...

MS SQL: Paging using MS SQL Query, sql query, ms sql
sql query, ms sql, final result: Hi Gary, You could do this. I assume you have a column which is unique like ID (I see 1,2,3,4,etc in your example). Now using that column you could do like for 1000 rows (10 in a page), you could specify in your where clause where ID = page # * 10 and...

MS SQL: Please help!, language script, web language
language script, web language, time church: Hi Randa You have great plan but I don t have any ready script for this. But if you are familiar with any web language script then you can create this whole script in 2 days. Just go through any 24 Hours books and start creating. I am on vacation (Diwali)...

MS SQL: Printer billing system, usernames and passwords, printer billing
usernames and passwords, printer billing, bible guide: Hi Hey, Just think about one problem. How u r going to put something in-between the printer dialog box. How will u, run a script that will access the user database and disable the print functionality. I recommend that u search the VB code or some...

MS SQL: Privacity in SQL Server, application response time, virtual private server
application response time, virtual private server, sql server database: Hi Marcelo Yes this can help u but this is costly. This is for companies who never share their data or where the application response time is important. But even web hosting is also a cheap solution and their don t touch ur data as well. Regards...

MS SQL: Problem in creating a query, consultation
consultation: Hi This will solve the problem Select FirstName, LastName, SUM(consultationFee), SUM(Drugcost), SUM(TestFee) FROM Consultation a, PatientDrug b, PatientTest c WHERE a.PatientID = b.PatientID AND b.PatientID = c.PatientID AND a.PatientID = MOHIT...

MS SQL: Problem in developing a Query, select sum, three tables
select sum, three tables, medical domain: Hi David Select (SUM(consultationFee) + SUM(Drugcost) + SUM(TestFee)) AS SingleValue FROM Consultation a, PatientDrug b, PatientTest c WHERE a.PatientID = b.PatientID AND b.PatientID = c.PatientID AND a.PatientID = MOHIT *********************************************************...

MS SQL: Problem in developing a Query, three tables, medical domain
three tables, medical domain, select sum: Hi David To join three tables you should have some joining columns in all the three tables. Let say Consultation PatientDrug PatientTest Now as per my understanding of medical domain you must have PatientID in all these tables. So we can write this...

MS SQL: Problem SQL Querying., aggregate functions, transac
aggregate functions, transac, particulars: Hi Rohit You can use GROUP BY clause to get data that is grouped by DATE, but we have to use aggregate functions in select clause or put all the columns in GROUP BY statement. Select Distinct Date, count(*) as Total_Records_for_that_date From Transac...

MS SQL: performance problem with SQL code, ms sql server 2000, ms sql server
ms sql server 2000, ms sql server, sql server 2000: Hi I think there is no need to read each line while populating the DW. Can you send me the exact requirement, any transformation that you are performing while populating DW. There are so many ways to transfer data without reading each line. So please...

MS SQL: project, microsoft server, server thanks
microsoft server, server thanks, microsoft: Hi Agwa I am very much ready with my help about Stored Procedures and Triggers. But can you be little more specific about the kind of help required. You can easily check for sytax in Microsoft Server Books Online (Installed with SQL Server). Thanks...

MS SQL: Query Help, india madras, india bombay
india madras, india bombay, ms sql server: Dear Rajiv, There are two basic things we can do. See the day and month will remain the same only the year part for financial years start and end may change. 1. Datepart( yyyy , datecolumn) 2. convert(char(4), datecolumn, 112) Also I have used the 2 option...

MS SQL: Query Help, b count, store id
b count, store id, purchase details: Dear Rajiv, You may need to use self join for two times to get the things done. Try to fetch data for Sales from the first self join and data for purchase from the second self join. Both should be left joins to get blank data where nothing is present for...

MS SQL: Query Help, india madras, india bombay
india madras, india bombay, ms sql server: Ok.......Sorry Thats great Rajiv, you can change my existing procedure to do the same. I don t think that the procedure will take time with 100,000 records, but obv. this is not the super optimized code and a lot depends upon indexes/stats/partitions...

MS SQL: Query from multiple info input on form, comma seperated, input mask
comma seperated, input mask, range values: Hi Jessica Thanks for the rating. I got it, You have something like D77778, D77805, D77779 in text box and you want to get all three corresponding rows from your table. This soultion will solve this issue sql = select * from tableName where FieldName...

MS SQL: Query, case qty, information thanks
case qty, information thanks, report software: Dear Brian You can convert a data type into another data type using CAST or CONVERT function of Microsoft SQL Server. And I think you are not using Microsoft product. I just wanted to tell you that my all examples are only Microsoft SQL Server 7.0...

MS SQL: Querying, mm ss, ritesh
mm ss, ritesh, time field: Hi Ritesh This will help u if u have stored data in varchar field select * from Table_Name where right(DateTimeField, 8) between 18:20:00 and 18:35:00 ______________________________________________________ if u have stored data in datetime...

MS SQL: Question, database management system, consistent data
database management system, consistent data, database users: Hi Imran This is all I can think of DDBMS. Stores logically related database over physically independent sites. A distributed database appears to a user as a single database but is, in fact, a set of databases stored on multiple computers. The data...

MS SQL: query not giving expected result, result table, null values
result table, null values, datetime: Dear Anand, Here, you can use group by on the final query on service and hostname, but you need to either use isnull(deploy_schedue, cast(null as datetime)) or decide the date as the default. This will help you in dealing with null and may get you the needed...

MS SQL: query help, sql 2000, ms sql
sql 2000, ms sql, max value: Hi Safwat, You could do this in SQL server only if you have some column which is serialized, like an identity column. In this case, you could do programatically by selecting the top 10 in the query and also gettting the max from the top 10 results. The...

MS SQL: More query questions, set of numbers, time thanks
set of numbers, time thanks, apologies: Hey, sorry again for the very very late reply. You re right in saying that you use an update statement using a replace. Here is the query then: UPDATE mytable set myfield=replace( myfield, ___ , ~~~~~~ ) where myfield like %___ Let me know if...

MS SQL: question on sql, max salary, qn
max salary, qn, desc: how to retrieve last ten records or table? if you have some primary / identity column, then it will be easy. SELECT TOP 10 * FROM urTable ORDER BY primaryKey DESC 2 SELECT MAX(Salary) FROM urTable WHERE Salaby (SELECT MAX(Salary) From UrTable)...

MS SQL: RDBMS-SQL, microsoft sql server 2000, microsoft sql server
microsoft sql server 2000, microsoft sql server, sql server 2000: Microsoft® SQL Server™ 2000 uses locking to ensure transactional integrity and database consistency. Locking prevents users from reading data being changed by other users, and prevents multiple users from changing the same data at the same time. If locking...

MS SQL: RETURN VALUE, open comm, personal sales
open comm, personal sales, initial catalog: The RETURN statement can only return integers. So return @result is forcing @Result to be converted to an integer... Here s a snip from the Books Online RETURN Exits unconditionally from a query or procedure. RETURN is immediate and complete and...

MS SQL: Recognizing NULL values, boolean data type, integer data type
boolean data type, integer data type, sql server 2000: Hi Rami Sorry for late reply, But I am still working on your issue and hopefully you will get a complete answer for your question. If you are interested in SQL Server then please read Inside Microsoft SQL Server 2000 . Trust me this book is not for...

MS SQL: Ref: databases, time reliability, mahabir
time reliability, mahabir, fault tolerance: Hi Sunil, There are several databases around. To build one it takes some amount of technical now-how. As for someone builing on own, depends how much time/reliability/secure and fault tolerance is involved. Generally folks or services are involved for...

MS SQL: Ref: question, mahabir, database knowledge
mahabir, database knowledge, database programs: Hi 1. What is involved in building a database. Any RDBMS like SQL Server/Oracle and somebody with database knowledge. 2. Are there online services that can show someone without experience in building databases how to build a portal or a database...

MS SQL: Remove Field from Table, microsoft sql server, drop column
microsoft sql server, drop column, drop index: Hi Gary Frankly, I don t have any idea about Aqua Data Studio. If you are using Microsoft SQL Server then connect through Query Analyzer (2000) or Management Studio (2005) and use this sysntax to drop fields. Alter Table tableName drop column ColumnName...

MS SQL: Replace text, sql 7, sql query
sql 7, sql query, text column: Hi Gary, Firstly I assume you know that text is a reserved word in TSQL. If you want to use it as a column name you got to address it always as [text]. Secondly what you are doing is absolutely right. It will work . Try the equivalent on Northwind...

MS SQL: Restore SQL7 .Bak To SQL2000, sql server error, server error log
sql server error, server error log, device error: make sure that the Device is switched on and if it is already on, then check whether it is being accessed by any other process. Also make sure that the device has been configured correctly are those SQL 7 and 2005 running on the same server ...

MS SQL: Restore SQL7 .Bak to SQL2000, ldf, initial location
ldf, initial location, disk c: Hi Gary This is very small problem. First of all h:MSSQL7DATADATAECT.mdf is incorrect...... It has to be drive:filename.mdf , you are missing here. Now general concepts....see when you take backup it makes a record of existing location of...

MS SQL: rank, attachement, common files
attachement, common files, c program: Hi Sue Ok, so want to implement the same in MS Access. Frankly I don t give much advice on MS Access and thats why I said trigger in SQL Server can achieve the same in a easy way. But the site you suggested is doing the same thing in VB module, so go...

MS SQL: relating different tables, server monitoring software, substring function
server monitoring software, substring function, table server: Hi Mike First of all, As a SQL DBA/Developer I want to tell you that please remove the space seprated rules from Relator table. You may get a solution for your current problem, but I am 101% sure that U WILL FACE 1000 PROBLEMS LATER. Right now I will...