• Database replication in SQL Express

    Please suggest me some way about how to replicate data at regular intervals among two or more systems having its own SQL Express database.

    jyotikumari275 pointsBadges:
  • What’s the best way to create a cloud-based SQL database?

    We have a website that's currently being hosted on Amazon S3 and it's working fine. But we have run into a problem with our data (and it's static). So the next step we're looking at is to create a SQL database in the cloud so we can store user data. Could we possibly do this through Amazon AWS or...

    ITKE351,865 pointsBadges:
  • SQL 2000 migration to SQL 2005 – need to preserve user security

    Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an "orphaned" database.  Our app stops working if a database is simply detached/attached to...

    Vitomizer5 pointsBadges:
  • Database Creation

    Recieving an error for database creation permission for sql 2005. Please advise

    Praya5 pointsBadges:
  • Update Data SQL Server From AS400

    Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

    JLH10 pointsBadges:
  • Create a database in SQL Server 2005

    Create a database in sql server 2005 but database name passed as parameter into a stored procedure

    Let5 pointsBadges:
  • Who is using a database in SQL Server 2008?

    I’ve never seen this problem before. I went to change the name of a database in SQL Server 2008, but got hit with an error message saying that the db has to be exclusively locked to do this. So obviously someone else is using the database, but I don’t know who. We have a rather large...

    ITKE351,865 pointsBadges:
  • Free IT Book: Microsoft Windows 7 Administrator’s Reference

    This week's IT book giveaway is for the Microsoft Windows 7 Administrator's Reference: Upgrading, Deploying, Managing, and Securing Windows 7. Interested? All you need to do is answer one of the questions below and post the link to your answer in the discussion area of this question. JavaScript...

    MelanieYarbrough6,345 pointsBadges:
  • How to insert Hex values through SQL/400

    Hi, I'm creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can be possible to insert...

    color10 pointsBadges:
  • Access

    How do I access SQL data in software?

    shafi5 pointsBadges:
  • I need the date to go to my dataTable

    I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont see a place for it. Private Sub...

    brendaStrub5 pointsBadges:
  • Changing web server can access back office app through local host but not when it is on DMZ

    We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into our database. All the ports that...

    Elziz15 pointsBadges:
  • Database

    How to create a database of prison management system using SQL?

    abuhafsah25 pointsBadges:
  • SQL table connectivity via odc

    Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

    tswanson3005 pointsBadges:
  • VPN Connectivity Issue with SQL Database

    My Issue is with a VPN Connection. I have an SQL Data Base set up on a Windows XP Pro machine. We are using a Clear Motorola WFIMAX Modem and an AirPort Extreme Router. I have port 1723 Forwarded and Out going and Incoming Connections created on both Server and Client.  The Server has a version of...

    greatjubee165 pointsBadges:
  • VPN Hollander Powerlink Server issues

    I set up a VPN connection to our Hollander Powerlink Server when I try to set up the client software I get and error message unable to validate the power link server. I have all the drivers mapped on the client machine. during set up I try to map the SQL but I am having trouble making the...

    greatjubee165 pointsBadges:
  • How to search more than a word in a column SQL database?

    i have an array of words to be search in my sql database like: searchword = array(['Arrays','Logistics']) for word in searchword:     conn.BeginTrans()     cursor = conn.Execute("SELECT idf FROM instance WHERE instance='"+ word +"'")     conn.CommitTrans() but some of the searchword cannot be...

    Semantic855 pointsBadges:
  • SQL database design

    i have slary system using vb.net  and sql server there is  27 user the compute up to  700 employ salary every monthe i collecte (700 *27) number of row and adding them programaticaly to a table called salary the table salary have 40 column with one primery key  is there any proplem with this...

    msmj8675 pointsBadges:
  • Connecting to SQL Database

    We are no longer able to connect to our SQL database or open the DB manager on Windows Server 2008. This is SQL 2005 how can we troubleshoot this issue? We have a 2.9gb database and backups from each night.

    NewnanIT1,110 pointsBadges:
  • Visual Basic and SQL database design

    i have vb.net & sql  application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I'm afraid  it Will give a bad performance  or have (out of memory massge) so i Made a solution (i...

    msmj8675 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following