• Crystal Reports Duplicating Records

    Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...

    Simonlevey5 pointsBadges:
  • when i print a work order in the application i need to update a field in a sql table to true

    when i print a work order in the application i need to update a field in a sql workorder table to true

    Tanjaatbrenlo40 pointsBadges:
  • What backend works best with Cognos frontend?

    Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren't sure if that is the best option. Any suggestions?

    Jayne46245 pointsBadges:
  • Retrieving System information

    I need to retrieve logins and users for all databases by server for SS2000 - 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the...

    Calcindor5 pointsBadges:
  • Are there any specific considerations we should be aware of as we attempt to migrate applications to a Hyper-V virtualized machines?

    We have major applications (Exchange 2007 and SQL 2005) that we have in a mission critical configurations “clustered.” Are there any specific considerations we should be aware of as we attempt to migrate these applications to a Hyper-V virtualized machines? Are there any resources available...

    ITKE364,180 pointsBadges:
  • Virtual machine failover

    So in a failover from a failed node, no data is lost there is just a longer interruption in service compared to live migration. Does the guest know anything happened or does it continue on as if nothing happened? Anything special for a virtual SQL or Exchange server in a failover scenario?

    ITKE364,180 pointsBadges:
  • Capitalize First Character

    How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example "QUESTION" or "question" should be converted to "Question".

    VelameLaCosa110 pointsBadges:
  • SSRS 2008 – Connection to Oracle 10g seems to be timing out

    I'm running SSRS 2008 via Visual Studio on my desktop. The data source for my report is an Oracle 10g database. The report runs fine when the parameters are set to limit the number of rows returned, but when I change them to return more data it eventually times out. The same query runs in less than...

    Jeffkopsa20 pointsBadges:
  • Changing UNC paths

    I have 138 rows of Universal Naming Convention (UNC) paths. Part of each path is constant and part is a variable. How do I change the constant portion of the UNC path and keep the variable intact? For example: •\serverpathdir1dir11 •\serverpathdir2 •\serverpathdir3dir31 constant part...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SSRS 2000 Support Ending Date

    Is there a data set when SSRS 2000 will no longer be supported?

    Stoptherain5 pointsBadges:
  • FirstIAM page of a table in SQL Server 2005

    Hi, Can you please explain how is the "FirstIAM page of a table" is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server 2005 :-)

    JudeAj5 pointsBadges:
  • 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:
  • 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:
  • 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:

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