I need to spell check documents about SQL Server applications. These will often mention "database..table". How do I get Word to ignore the double full stops?
Please help me how to install MySQL on Windows 7. When I tried to install, I am getting errors as:
The security settings could not be applied to the database because the connection has failed of the following errors
ERROR NR:1045
Access denied for user 'root@'localhost(using password yes).
I tried to uninstall MySQL completely and install again, but it shows this error again and again. I have changed my firewall setting also and tried unstalling antivirus sotware too. But it also did not work.
If I have a master DNS that is not bind - can bind still slave to it? (ie does it use the DNS protocol or something else?).
Kind of related - but do people still do this or do they use some other form of data replication to keep DNS records in sync to the slaves (ie file/database copying)? I would like to have the slaves refreshed as fast as possible so I am thinking normal slaving with is expiry/poll based might not be optimal?
I have an exchange sever 2003 installed and working. I have a new exchange 2007 server on another network. The two networks are completely separate with no connection. How can I take the 2003 mailboxes and put them on the new 2007 system? The move mailbox normal option on 2007 will not be able to see the old 2003 exchange server.
I was hoping I could just copy the database and mount it, but this doesnot seem to work.
Thanks
OSQL -S 127.0.0.1 -U sa -P password
RESTORE DATABASE DATA FROM DISK = C:\backup\data.dat
GO
EXIT
This is the batch file.
but after I run the OSQL -S 127.0.0.1 -U sa -P password,
the dos command start with the line
1>
After that, the batch cmd can't run. How can I fix this problem? thz.
Solaris Korn Shell
I am writing sql reports to an oracle database, spooling them to a file and emailing them with mailx. I use the syntax below. The reports do not format properly, unless I use the Courier New font. How do I set this with mailx?
mailx -s "MY REPORT, date +'%D %r " -r "REPORTING SYSTEM" [email protected]< /mydir/mysql.log /dev/null
I have an application that takes a long time to open odbc connections (like 20 sec)
also takes forever using arcmap and arcsde
but when I try the connection on the odbc data source administrator, it tests it really fast
Does anyone have any idea of what my be causing this?
btw the application works fine in another computer with another database
thanks.
I get this two Exchange 2010 Global Address book related event IDs:
Event ID 9331 MSExchangeSA
OABGen encountered error 80004005 (internal ID 50101f1) accessing the
public folder database while generating the offline address list for
address list '/'.
-\Default Offline Address List
and
Event ID 9335 MSExchangeSA
OABGen encountered error 80004005 while cleaning the offline address
list public folders under /o=xxxxx
xxxx/cn=addrlists/cn=oabs/cn=Default Offline Address List. Please
make sure the public folder database is mounted and replicas exist of
the offline address list folders. No offline address lists have been
generated. Please check the event log for more information.
-\Default Offline Address List
It is Exchange 2010 SP2 sitting on Windows 2008 enterprise edition.
Essentially the issue is that the global address book is not being updated on Outlook clients. We are using Outlook 2007 and 2010.
So far I have tried running the following command:
Update-FileDistributionService -Identity ExchangeServer -Type "OAB"
And I tried this solution as well:
1) Make sure the Microsoft Exchange System Attendant is running. It
will be set to start automatically by default, but it doesn't. This is
a known issue. Start this service manually. When running, you will not
get an error when trying to update the GAL.
2) "Apply" any changes made to any address lists before the GAL will
update Outlook properly. In Organization Configuration - Mailbox in
EMC, view the properties of the Default Global Address Book in the
Offline Address Book tab. In the properties window, select the Address
Lists tab. This shows which address lists makes up the GAL.
3) Close the properties window and select the Address Lists tab in the
Organization Configuration - Mailbox. Right-click each address list
used by the Def GAL and click "Apply" (make sure the "Immediately"
radio button is checked).
4) Last, go back to the Offline Address Book tab, right-click the GAL
and select "Update".
After a few send/receives in the Outlook clients, their Glogal Address
List should update to show the latest changes.
Neither one of those solutions helped. So I am not really sure what to do here. Also, I am aware of changing registry on each local computers, but it would be close to impossible as we have 8 offices in 3 different countries.
Any suggestions?
EDIT 7.XII.2012 @ 10.35
I forgot to mention that we did rebuild the address book and that didn't help.
Possible Duplicate:
Auto-tagging MP3s
I'm currently using musicbranz picard to tag files that don't have any usable tagging information. For some reason, currently none of the files I trying to ID seem to be identified, despite some of them them being artists who are almost certainly on musicbrainz.
So, I'm looking for something that uses an alternate database and does the same thing - to identify unknown music files off an audio fingerprint. Windows is preferred, but I would be fine with any of the big 3 OSes (Windows/Linux/OS X).
I'm dealing with a server running SQL Server 2000 SP1, and the logical filenames for one of the databases appear to contain trailing spaces. That is, this query:
select replace(name, ' ', 'X')
from sysfiles
Returns the expected names plus a long string of Xs.
How can I deal with this? I've tried running ALTER DATABASE... MODIFY FILE using the name (with and without spaces) and get an error message telling me the file does not exist.
Hello ,,
I want to own an Internet Security software , but I prefer that it has following properties :
Not a heavy one that killing the machine (Like Norton) .
Delete the viruses , and don't keep it after clean it .
The most important off all : Has an Offline databases that Can I download and add to program database without connecting to Internet (Not Like KIS 2010)
Containing (anti spam -anti Virus - Fire wall - ....... )
So what is in your mind?(Don't tell me AVG I tested it)
I am planning to implement a Sales force automation software where there will be 50 PDA devices having sql server CE 3.5 connecting via web sync merge replication to central SQL Server 2005 main Database via a IIS server.
1) IIS Server Win 2003 Server 2) SQL Server 2005 Standard
3) SQL CE 3.5 having in 50 PDA Devices.
How many licenses are required for each Servers ? What is the licencing model
Hi,
I have a client who is looking for a solution to integrate cctv with a (any) ANPR solution that can,I assume recognize the number plate of cars and store in a database and has the ability to post this data to other backoffice applications, crm, marketing app. etc.
Is there any ready software to do this ? Or your recommendations ?
I'm using the standard Database Model Diagram template in Visio 2007.
When I try to connect two entities, the line is a "one and only one" type. I need a "zero or more" type, but no amount of line editing will change the line.
Is this a bug? The Visio help does not describe how to do this and the MS website turns up no results for 2007 (plenty for 2003, but the menu options it refers to are not in 2007).
I have a Solaris 11.1 server running an Oracle database. I want to read the environment of a running oracle process, as the oracle user, like this:
$ id
uid=100(oracle) gid=100(oinstall)
$ ps -fuoracle | grep pmon
oracle 1651 1 0 10:25:37 ? 0:01 ora_pmon_TESTDB
$ pargs -e 1651
pargs: cannot examine 1651: permission denied
$ ls -ld /proc/1651
dr-x--x--x 5 oracle oinstall 864 Nov 23 10:25 /proc/1651
How can I grant permissions for oracle to read processes that it already owns?
Lets say I have an application server and a database server on Amazon EC2. If the db server fails and restarts, how can the app server know the new internal ip of the db server and automatically continue working with it?
I'm going to do a clean install of Windows 7 in my laptop and one of the thing that I really want the way it is is Firefox. I know I can get the addons easily and the bookmarks also, but I also like to export my browsing history, the Awesome Bar database and my about:config customizations.
Is there a way or tool to do that?
I have some data that is from a Postgres database dump (not csv or anything) and I am looking to get it into MS SQL. Is there an easy way to do this or a free tool that doesn't have limits on data import size etc?
The Postgres is on a Debian VM and I could export it to csv in there but I am new to Linux and don't know how I would transfer it from the VM to Win 7.
Thanks
I'm planning to set up transactional replication for a 100Gb SQL Server 2008 database. I have the distributor and publisher on the same server, and am using push subscription.
Should there be a performance impact on my publisher server when it creates the initial snapshot, and synchronises it with a subscriber? From what I've tried so far on a staging server, it seems to slow right down.
Is there a better way to create the initial snapshot without impacting my production publisher server?
hi,
I'm trying to connect to database of my customer server (phpmyadmin) and I get the following error:
2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 111
this is a server bug right ? If I don't have access to the server there is nothing I can do...
Thanks
Hi all,
We have a database file (foxpro) on a Windows share (2003 server), we're having some problems where the program that writes to this file has to retry as the file is locked, this all happens very quickly and within a few seconds the file is available but the problem is it shouldn't be locked. Does anyone know how we can view what's locking it? Any tools available?
Thanks
James
I am interested in a utility or process for monitoring disk IO per file on CentOS.
On Win2008, the resmon utility allows this type of drilldown, but none of the Linux utilities I have found do this (iostat, iotop, dstat, nmon).
My interest in monitoring IO bottlenecks on database servers. With MSSQL, I have found it an informative diagnostic to know which files / filespaces are getting hit the hardest.
I'm using myphpadmin to manage the databases and I'm new to SQL in general. Am I suppose to keep an open anonymous user on localhost so things like drupal can access mySQL? It seems like having a non-passworded root on my server's hostname is retarded but I don't know what I'm doing with this in general. The user who's name starts with a b is the one I use to login and do things like make a database.
While installing SCOM 07 R2 Database component on our DB server I get this error...
I've gotten the same error on the following configurations.
Windows Server 2003 & SQL Server 2008 SP1
Windows Server 2008 & SQL Server 2008 SP2