alter database
right click on the database –. go to properties –> go to options –> at last u can see the state clause in this u can see the restrict options –> there u can set the multi_users

View Answer   |  April 11, 2011  12:36 PM
Northwind sample database, Run Commands, SQL Server

Database backup terminating abnormally
u should have to change the recovery mode to full for the particular database. then try on it it will work

View Answer   |  April 11, 2011  12:25 PM
Backup, Database Backup, SQL Server 2008

How to Join MySQL database box to a Windows Server 2008 DNS
If the server that will be running MySQL is a Windows server then you just add it to the domain like any other server. If it is a *nix box then you don’t add it to the domain. There are patches which you can install on the machine so that it can see AD. In [...]

View Answer   |  April 10, 2011  8:51 PM
Database, DNS, LAN, MySQL Database, Networking, Server Architectures, Windows Server 2008

how I can connect my local SQL server2008 with another one via internet?
please enable tcp/ip in services in both of the server and enable the remote connection in both of them. first ping with the ip address in command prompt. after that open the sql server , give the ip address of the other server in the server name and at the login place give the login [...]

View Answer   |  April 9, 2011  12:10 PM
Remote access servers, SQL connectivity, SQL Server 2008, SQL Server connectivity

MSQL Auditing
if the database is in u r server then u can select the data which u have given. we can select the data with unique key column id in table we have give max id for particular column from then we can select the data as u r required from FIFO method

View Answer   |  April 9, 2011  11:58 AM
Auditing, dot.net, MySQL, MySQL query, SQL, SQL audit, SQL Query

I want to create backup of SQL database and set a password.
Make a backup of the database, and specify the WITH MEDIAPASSWORD = ‘YourPassword’ parameter. This will secure the backup file with a password. This method will be removed from a future version of SQL Server. However it isn’t had to bypass this password. You are better off to encrypt the database using Transparent Data Encryption, [...]

View Answer   |  April 9, 2011  6:59 AM
SQL Backup, SQL Data Types, SQL Server backup, SQL Server database, SQL Server security

Recovering lost data from SQL Server 2005
The only reason that the error would come up would be if SQL Server already had one or more of the records there.

View Answer   |  April 2, 2011  7:08 AM
INSERT statement, SQL Server 2005, SQL Server 2005 backup, SQL Server backup

User Accounts in Access 2003
Which file did you transfer to the other computer? If it was only your application database then, you need to copy your security/workgroup database to the other machine as well. This is called system.mdw by default. You need to put it in the default location where Access looks for it. Or, you can specify the [...]

View Answer   |  March 31, 2011  2:15 PM
Access 2003, Access 2003 forms, Access 2003 Security, User Login Data

Database connectivity from Oracle Forms
When you connect your forms to the database, you specify a database alias, which is an entry in your TNSNAMES.ORA file. You need to create an entry for the new database in your TNSNAMES.ORA, and then use that alias as the host string when connecting. HARSH:– i would like to improve this answer a bit… [...]

View Answer   |  March 30, 2011  7:45 AM
Database connectivity, Legacy applications, Oracle connectivity, Oracle Forms

how delete 12,33,200 rows in oracle table
How many total rows are in the table? If not much more than the rows you want to delete, then you might copy the rows you want to keep into a new table and truncate the old table and then copy the records back. Otherwise, you will need to make sure your rollback segment is [...]

View Answer   |  March 28, 2011  4:20 PM
DELETE statement, Oracle Table

Is experience of desktop administration will take into account for a network administrator profile
Good Question and I appreciate it. As a Desktop Administrator, it is mainly focused on a broad range of issues on the client OS, various desktop applications, configuring and connecting mobile devices, wi-fi knowledges and of-course a fair knowledge of networking (specially on peer to peer lan). As a Network Administrator, it focuses on 1. [...]

View Answer   |  March 28, 2011  1:17 PM
CCNA, CCNA Certification, Desktop administration, IT careers, Network Associates

IT training for career switch
U have also repairing knowledge of PC, Laptops etc a part from ur regular job. If u really want to secure ur future, better to get for a certifications relating to hardware, coz, it helps u to get more job and u have good working knowledge on this ! If u r really interested on [...]

View Answer   |  March 28, 2011  9:29 AM
IT careers, IT training, IT training and certifications, IT training and coursework

Does cellular routing technology exist?
Sounds alot like some simple call-forwarding: Cell calls the extension, Call forwarding redirects call to Paging device (keychain, beeper, alternate cell, etc)…

View Answer   |  March 25, 2011  9:38 PM
Cellular, Cellular networks, Database, Routing, Routing and Remote Access, SIP

MySql Select multiple columnsfrom distinct rows based on one column
<pre> ORDER SUFFIX ITEM DESCRIPTION CUSTOMER UNIT ORDER NUMBER NUMBER NUMBER PRICE DATE lsornm lssufx lsitem lsdesc lscust lsunpr lsdtor 342372 0 WP0114517102265 GALV MI 150 TEE 001503 .9440 20110303 342372 0 WP0164000102585 3/4X2 GALV S40 STL NIP 001503 3.666565 20110303 342372 0 037721400 CMS-33 3/4 MXC C-STL UNION 001503 3.101600 20110303 342372 0 041500534 [...]

View Answer   |  March 25, 2011  8:35 PM
iSeries V6R1, MySQL, SQL statements, V6R1

Access 2007 button addition
create your table. pick a field to store the caption. create a button. for below I called it command2 under properties for that button clear the ‘picture’ field. create some code, under ‘on click’ for that button add the following. below prompts for string when they ‘click’ on the button Private Sub Command2_Click() Dim temp [...]

View Answer   |  March 24, 2011  4:17 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access forms

Sap enterprise portal
there is a very nice blog for sap ep on the web. SAP EP implementation – Personal experiences revealed step by step. Learn how to design, deploy and manage SAP EP. How to optimize performance, how to make a EP safe, how to make it highly available and scalable. available at following link. http://learnsaponline.blogspot.com/

View Answer   |  March 24, 2011  6:13 AM
IT careers, SAP careers, SAP Enterprise Portal, SAP EP

Free IT Book: The Accidental Administrator: Cisco ASA Security Appliance
Please note: IT Knowledge Exchange is only able to ship prizes to the US, Canada, the United Kingdom, and Western Europe. Entrants outside of those places will receive compensation in knowledge points. Refer to <a href=”http://itknowledgeexchange.techtarget.com/itke-community-blog/techtarget-contest-rules/”>TechTarget’s Contest Rules</a> for further information. Thank you, and good luck!

View Answer   |  March 21, 2011  4:18 PM
AS/400, Channel, CIO, Cisco ASA, CRM, Database, DataCenter, Development, Don Crawley, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

What wiki software do you recommend?
To the point answer…, and no long paragraph, use MediaWiki with confidence, it can be downloaded for free and host ur own wiki. MediaWiki a custom made, open source wiki software platform written in PHP and built upon the MySQL database. It is licensed under GNU General Public License and it is used by all [...]

View Answer   |  March 18, 2011  5:42 AM
Linux, MongoDB, MySQL, MySQL 5.0, PHP, Wikis

Updating a SQL Server record in a large table
Have you looked at the execution plan? maybe there is a problem with the index. Since you specified RecordID in the WHERE clausule SQL Server is using the PK index, regardless if you are specifying it or not.

View Answer   |  March 16, 2011  2:29 PM
INSERT statement, SQL 2005, SQL Database, SQL Server

Junk characters in CSV conversion through CPYTOIMPF
i observed this working fine v5r3 but i am using v5r4

View Answer   |  March 11, 2011  12:27 PM
AS/400, CLLE, CPYTOIMPF, CSV, CSV file format, RUNQRY