• 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:
  • Create new SQL 2008 database in external drive

    My local server using SQL 2008 Express is running low on disk space. Is it possible to create new databases or move a database to an external drive? If so, how is it done, configuration wise? Thanks.

    HermanHermit15 pointsBadges:
  • Updating SQL 2000 Data

    Hi I have a database with test card numbers, I have encrytpted the card numbers and updated the database, when i run a card scanner program on my MDF file it still finds the cards that i have updated. how can i get rid of these permanently. I have a deadline to apply this same principle to a...

    KH155 pointsBadges:
  • Insert values into database from form VB.NET

    Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want...

    Darthswift0040 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ssss12315 pointsBadges:
  • SQL Server backup to remote internet location

    We have one server with 2 SQL databases with size 1.5GB and 6GB, Daily new transactions are added to the system. Now we want a solution that this SQL gets backed up / replicated at some remote internet location on daily basis. Since we cannot transpot full 1.5GB file or 6GB file on daily basis, how...

    Amitguptaais5 pointsBadges:
  • SQL 2000 database recovery

    Hi, weve had an issue with a raid array meaning our sql 2000 cluster wont start. Weve recovered data to another server using backups, however were missing that days data as the backups hadnt started for that day and we have no tran log backups between those times. I have the original mdf and ldf...

    Charliev5 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Optimize SQL 2005 databases on a schedule

    How can I optimize my SQL 2005 databases on a schedule?

    NewnanIT1,110 pointsBadges:
  • Modifying a Stored Procedure

    The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don't want it showing up...

    DJandLO130 pointsBadges:
  • SQL Oracle for rolling the period return

    Hi ,  i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query .  return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should...

    Piyushr15 pointsBadges:
  • unable to create a connection to DB from SQL developer

    Hi, I was using SQL developer since 2 years, suddenly lost all the existing connections.Tried creating new connections, provided all mandatory fields and clicked "Test", it was success. But when tried connecting, no response. Also tried importing the connections, but throwing...

    Abc130 pointsBadges:
  • Networking solution

    I have a senario of SMB requiring a win2008 server, Apache web server, Sql database server, Exchange 2010. How many servers do I realistically have to get. 24 hosts with view to expand. And future interstate branches. Voip is a consideration also. VPN........ The site is 2 floors. No...

    Jasonjlewis45 pointsBadges:
  • Trigger or Stored for lock and unlock database for 15 minute

    Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password  on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive='false'. So can u please help me to give code...

    Programmer0075 pointsBadges:
  • Updating a SQL Server record in a large table

    We are using SQL Server 2005 and I have an SQL DB on it with 270,876 records in it. There is a PRIMARY KEY defined on the first field called RecordID (Identity field). The index name is PK_ListOfFiles_as_of_3-7-2011. If I execute the following command from the Query Window on the server it takes a...

    BDW65 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