• 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:
  • I’m interested in creating a web form that will deposit information into a SQL Server database.

    I'm interested in creating a web form that will deposit information into a SQL Server database. What's the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

    Eabouzeid175 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:
  • ORACLE-TRIGGERS

    Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time)...

    RizwanSharief30 pointsBadges:
  • clarification of the terms FRS vs SRS

    I'm often confuse with the term FRS and SRS - are there the same or if there's a diiference, can u please highlight what are the diffrences? Do we have to have both for software development projects or either one is good enough?

    Rohaz5 pointsBadges:
  • Lotus Notes to SQL Server 2005 via linked server

    I am trying to create a linked server on SQL Server 2005 to Lotus Notes 6.03. However, I keep getting an error. A system dsn was created with the Lotus NotesSQL driver (8.0). In creating the linked server on SQL Server 2005, Linked Server Name: Same name as System DSN Provider: Microsoft OLE DB...

    Awaller5 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:
  • Trimming Values with SQL Server Express 2005

    I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn't work for me. I can't use LEFT or RIGHT before the column because the column length is variable. I...

    Eabouzeid175 pointsBadges:
  • Insert and update DB2 from SQL Server 2000 using OLEDB

    I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error, but...

    Sandy555 pointsBadges:
  • Linking users of Access 2003 to SQL Server 2008 database

    We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

    Mike8005 pointsBadges:
  • Changing over to DR database from SQL 2005

    I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring...) mode.  How do I now access my DR databases if/when my production system goes down?  There does not seem to be any obvious...

    Swales1015 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:
  • How can we use SQL 2000 or latest with Visual FoxPro

    Hello Friends I want use SQL in visual foxprox. how can do it. I ready many website, but all answer not fully cleared. Please send me Solutions. My Computer (SQL Server 2005 and Coputer Name) name is SEMSVR. Waiting your reply.

    Abhiindia15 pointsBadges:
  • Users accessing SQL Server 2008 database

    how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

    Tablestructure15 pointsBadges:
  • Find the SQL value behind the decimal

    I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?

    Tslake9925 pointsBadges:
  • Event ID: 2803 and 17137 Question

    I have recently installed SQL 2005 Express and Symantec Backup Exec for Windows 2003 SBS. I have not created any backup jobs and do not have an Active SQL DB just yet. However the following Information Events are being logged under Application Event every 5 minutes. Is this normal and is it...

    PCJunkie870 pointsBadges:
  • How to split a column into SQL data..

    I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent;...

    Anamika8315 pointsBadges:
  • Can anyone tell me the best way to query Active Directory in SQL?

    Can anyone tell me the best way to query Active Directory in SQL? I'm using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I'm not sure what the best way to do this is.

    Eabouzeid175 pointsBadges:
  • SQL Writer error message – SQLDUMPER library failed

    error sql writer - sql dumper liabrary failed initialization install corrupt or tamper with

    Mmichals15 pointsBadges:
  • SQL Server 2005: Improving performance of Multiple Databases & LUNS

    I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as they are...

    Bulldog9815 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