• How to keep date format when creating Index on a Table

    I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to *DMY. How could I keep the...

    MacroJ20 pointsBadges:
  • SQL Server 2008 query To Find Columns with incorrect information

    This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                   ...

    Davewaltonuk20 pointsBadges:
  • How can I write a SQL query to get the database name ?

    How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

    KulkarniMandar5 pointsBadges:
  • surf control reports will not work after I enabled drill downs

    reports will not work after I enabled drill downs (v.2.6) Followed directions and enabled drill downs.  Now, reports and drill downs will not work after the day I reset the drill down.  Checked directions and no indication of making changes anywhere other that the configuration menu in...

    Jvidal5 pointsBadges:
  • SQL server query to search for table and column data in database

    I want to find the data in a table,but i dont know the table name and column name.All I know is the data and the database name .Is there a query to find the table and column

    Linu438910 pointsBadges:
  • Import data file into SQL database

    I need to import tis .dat file into sql database table having four column client-007092~WITCO clname-CORPORATION ,matter-0005,mattername-LAZY OIL V. WITCO

    Anamika8315 pointsBadges:
  • SQL 2005 Database Compare

    If there a way to compare two similar database to find where a Stored Procedure is different between the second database. Different in it not there or the Create Date or Modify Date is different?

    SQLNovice15 pointsBadges:
  • File access restriction for users in Logmein

    Hi, Please let me know whether logmein has a feature to restrict access of certain type of files for users. For example we have sql database having customer,account details etc.We need to restrict user who connects remotely to not to access account related files.

    Knw5 pointsBadges:
  • How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • Forum data transfer – SQL

    Hi, my question is: we're developing a new forum so want to learn how can we transfer the data in one or two tables in old forum’s SQL database to the SQL database of this new forum? that means we hope some posts in old forum to be moved to the new ones. Please give the steps to do it. Thank you...

    Bmblog20 pointsBadges:
  • Accessing MS SQL Server database from the iSeries

    How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting "host name not found" on as400. Thanks, Lan

    Lan1230 pointsBadges:
  • Multiple databases on a server – SQL

    My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

    Rajg5 pointsBadges:
  • Linking Visual Basics and SQL database

    I wish to know a code that can enable me to link visual basis and SQL database in an organisation.

    131113115 pointsBadges:
  • Create A Fixed Text File From SQL DB Table

    Hello programmers. After doing much research I am unable to resolve how or where to custom format each field of my SQL table output into my text file. Can someone help me with enhancing the below vb script? I need to reformat certain values. Do I do the formatting in the Dim section or in the if...

    Ilfoprog50 pointsBadges:
  • SQL saving off data created to copy into new database

    Data is created in one SQL DB for testing and then a new DB is created. Is there a way to save the data you need for testing in the new DB, so you don't have to create it each and everytime for testing?? Any suggestions would bew appreciated.  Thanks...

    Flyershockey25 pointsBadges:
  • MySQL database size

    Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

    Worktopm5 pointsBadges:
  • Pulling data from tables on different servers

    I have a join between a table on my local database and a table on a different database on the same server. I reference the non-local database with DatabaseName.TableName. Now I find that the non-local database might be on a different server. I tried ServerName.DatabaseName.TableName, but I got this...

    CO Bill120 pointsBadges:
  • SQL Server 2000 hang and shrink won’t stop

    I'm troubleshooting a SQL 2000 database problem. It's a db for our datawarehouse system that pull everyday data from host. Current size is 461Gb for db and 67Gb for log. Because of space concern, I want to detach the log file and create new, but today I cannot open the database locally or remotely....

    ITKE350,945 pointsBadges:
  • Backup of large amount of data

    I need some suggestions on a backup procedure. Here's what I am backing up to a 3.5 TB fileserver (RAID 5). 200 GB of application and document files from an application server. About 200 GB each on four medical imaging workstations. 100 GB of SQL database files from a SQL Server 100 GB of backed up...

    EyeT35 pointsBadges:
  • Replication and using EMC Autostart

    I am using EMC Autostart to monitor and mirror an application that uses a SQL 2000 DB. All worked well until I incorporated replication to keep certain tables synchronized with 2 other servers. The Autostasrt uses virtual names and IP's for clients to connect no matter which server is acting as...

    Ecann25 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