• Moving .MDF files from SQL Server 2000 to 2005

    Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to use an form field in a SQL from a combobox

    I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn't work. what is the...

    Haro5 pointsBadges:
  • DTS Package completes successfully but doesn’t run batch file

    I have a DTS package that creates and XML file and then FTP's that file to a location. I run the package manually and it works fine. I've created a job for it, run the job and it completes successfully, but go to look and the ftp from the batch file doesn't run. Obviously a permissions issue but...

    Bleeb45 pointsBadges:
  • How to automatically update Child Table with Insert Trigger and Table-UDF

    I have SQL Server 2008 and Visual Studio 2008 and am trying to automatically insert new records into a child table based on new inserts into its parent table. I know that this should be simple: via an insert trigger. However, the complexity is that the new records into the child table need to be a...

    Ironryan775 pointsBadges:
  • SQL Server connectivity on V3R7 AS/400 server

    Hello All, Can any tell me all the steps to coneect Sql Server to V3R7 version of AS/400. Thanks in advance.

    Pasrichavinu15 pointsBadges:
  • VB.NET – Can’t insert data into database.

    I used insert command it worked successfully that ur data has updated.But it is not showing in the database Plz look in the below code and tell me where iam wrong Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

    Shaz255 pointsBadges:
  • SQL Server 2005 -I want duration from the condition below- without cursor would be preferred

    I have the following table: CREATE TABLE [dbo].[DurationCalc]( [Id] [int] IDENTITY(1,1) NOT NULL, [ContractId] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Status] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ModDate] [smalldatetime] NULL ) ON [PRIMARY] And the following are the...

    SqlX15 pointsBadges:
  • Concatenation

    I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?

    BGramby15 pointsBadges:
  • System hangout

    I have client working on a HCL pc with 2GBram core2 processor he is working on SQL server the problem is that the performance goes down in the evening and hangoff and he even could not open his network drive can any one you could suggest some solution for this problem

    Udaykirak15 pointsBadges:
  • Transact SQL stored executed from AS/400 CL program.

    How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

    Jcorzine20 pointsBadges:
  • Export SSRS Report to Microsoft Excel

    Hi, I am a beginner in SSRS. Please guide me to export SSRS report i.e. .rdl report to an excel sheet.

    AmitJoshi14310 pointsBadges:
  • SQL Server Management Studio

    SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired..... I am only running the mgmt piece only. How do I get this ability back on my pc?

    Ssutton910 pointsBadges:
  • Visa and SQL compatibility issues

    Do you have any solutions for the compatibility issues I am having with Microsoft Vista and SQL server Data Engine?

    SQL Server Ask the Experts2,585 pointsBadges:
  • AD Domain Admin permissions to SQL

    Can a Domain Admin grant himself permissions to a SQL database? Or, put another way, can a Domain Admin make himself equivalent to the SA account?

    Kenkizer5 pointsBadges:
  • How do you add Name and mail to Address fields to a grouped report.

    How do you add Name and Address fields to the body of a Grouped table report?

    Glstevens5 pointsBadges:
  • SQL 2005 Password

    If you move a sql 2000 database to sql 2005 which admin password does it have now.

    Jabbman4220 pointsBadges:
  • Oracle SP syntax issues

    We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can't seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • query for join

    i have 2 tables unittypes,rules unittypes has unitid and description unitid description A1 description1 A2 description2 A3 description3 rules has id unitid 1 A1,A2 2 A1,A3 i am trying to get it to get a resultset like 1 description1,description2 2 description1,description3 the sql i wrote was...

    Rampradeep5 pointsBadges:
  • connetion failed ,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL

    I enabled remote connections in sql server 2005 configuration and services but also it giving same plz help iam trying this from three days

    Shaz255 pointsBadges:
  • Executing Oracle stored procedure from SQL server

    Using a linked server I can't seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider "MSDAORA" for linked server "PASSRPT" returned message "Syntax error in {resultset...} ODBC...

    Fishman15 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