• 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?

    ITKE372,130 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:
  • 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:
  • 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:

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.