• WSS3/MOSS Search no wildcards?

    When I search in WSS3 or MOSS, I must type a full word and I cannot use wildcards. Examples: "Wilso" will not find "Wilson". "Wilso*" will not find anything. "Wilson" will find all documents with Wilson in the name or in the document body (content search is working). Is there something I haven't...

    FWilson15 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • Trigger Use in SQL Server 2005

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • SQL Server 2005 database conversion

    Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.

    Anto5 pointsBadges:
  • Slow outer JOIN after delete rows

    Hi, I've tried this on two installations of SQL Server 2005 service pack 2. If I delete rows of a table, an outer join on the empty table is extremely slow...if I truncate it's ok, if I delete with the tablock hint it's ok. Any ideas why? The code to reproduce this follows, the outer join takes...

    dpaproskijr5 pointsBadges:
  • Update a Date_Time Field

    I'm trying to update a DATE_TIME field to a NULL value. When I run the script below I get an error. Any ideas on what I'm missing? UPDATE Orders SET CONFIRMATION_DATE_TIME = ' ' WHERE ST_ID = 102690 ERROR: Msg 245, Level 16, State 1, Line 1 Syntax error converting the varchar value 'Ê' to a column...

    DJandLO130 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • Restoring a deleted table in SQL Server 2005

    How do I restore a deleted table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • Stored Procedures in SQL Server 2005

    Will you please explain me about Stored Procedures in SQL Server 2005?

    Rajanarina110 pointsBadges:
  • MS SQL SERVER (BKUPEXEC) Services wont start

    Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my SQL...

    Ahmyown30 pointsBadges:
  • Transfering table data from one database to another

    I am using SQL Server 2005 i m inserting some data from one database to another. both Servers are resided on different machine.

    Pankaja5 pointsBadges:
  • Duplicate SQL Server 2005 database

    What is the best way to duplicate a SQL Server 2005 database to another server as a standby machine? Can I do this with another installation and some scripting? I have a separate box with SQL 2005 already installed. Can I backup and restore from one machine to the other using scripts and no human...

    ITKE409,490 pointsBadges:
  • Avoid duplicate entry in database through Visual Basic 2005

    I have made a program in VB 2005 with SQL 2005 as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when I enter an already existing id. matching all three fields and not allow duplicate entry.

    Sukas10 pointsBadges:
  • Sql server 2005 – query

    How to write SQL query to calculate second highest salary in Emp Table using "Top" Keyword

    DotNetj5 pointsBadges:
  • MS Project Server errors

    I have MS Project server 2007 (S1), Project pro (2007), SharePoint Server 2007 (language pack [Turkish] installed on Server 2003 with MS SQL Server 2005. I have only one farm. I can see when I create a project on server and client side. however whenever I want to see preview of a task, it gives an...

    Mahirkarabacak15 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 pointsBadges:
  • How can we use SQL 2000 or latest with Visual FoxPro

    Hello Friends I want use SQL in visual foxprox. How can I 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:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Impact on application after upgrade from SQL Server 2005 to SQL Server 2008?

    What would be impact/changes to be done in my application which is using general SQL for upgradation from SQL Server 2005 to SQL Server 2008 ?

    Vht5 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.

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

Following