Questions & Answers

  • How to paginate and view results in SQL Server 2012?

    I’m trying to set pagination within SQL Server 2012 so that you can follow the total number of pages while adding data. Anyone know how to do that?

    ITKE342,970 pointsBadges:
  • Error message while trying to login to SQL Server 2008 R2

    I've been working on this for weeks now but I continue to get this error message when I'm trying to login in SQL Server 2008 R2. 80040ed4 Failed login for user 'myuser' Can anyone explain to me what this error message means and how I can solve it? Thanks!

    ITKE342,970 pointsBadges:
  • Having problems with THROW SQL Server 2008 R2

    I’m having issues in SQL Server 2008 R2 Management Studio where it does not recognize my throw as detailed below: incorrect syntax near Throw I am trying to set things up so that my website throws an error whenever someone enters the same value twice Begin Try insert into BusinessID (BusinessID)...

    ITKE342,970 pointsBadges:
  • Dynamic vs. Stored Procedure table inserts

    I just finished making some code changes to get around a problem. I changed my code from doing a dynamic insert to using a stored procedure. Originally it was 20 lines of code for the dynamic process. Doing it the stored procedure way, by the time you defined all the parms it was 107 lines of vb...

    ToddN20008,785 pointsBadges:
  • IE10 popup

    How to get rid of request to download/save unwanted file from unfamiliar website?

    dkerna5 pointsBadges:
  • Outlook Invite

    How do you remove the When and Where from the body of the Outlook invite email?

    dks195125 pointsBadges:
  • 508 Compliance

    Is Siebel considered to be 508 Compliant?

    sweiler0015 pointsBadges:
  • How to control order of jobs run in batch

    In this user's CL program, he has 3 jobs and he wants to submit all jobs in qbatch. The catch is he wants to run the third job after the first and second job have already completed. How can he control this? -- Michelle Davidson, editor, Search400.com

    MichelleDavidson435 pointsBadges:
  • Need to know whether a job is completed

    Hi, I need to submit 2 jobs JOB 1 and JOB2 but before doing a sbmjob on JOB2 i should make sure that JOB 1 has ended. How can i do that during program execution. Thanks.

    Rpgle25 pointsBadges:
  • VMware online certification

    Hello, recently I have done VMware ESX 4.0 server from an Institute but that Institute is not authorized by VMware organization. So my question is am I eligible to set in VMware online certification exam or not?

    VM215 pointsBadges:
  • Converting fron a cisco 1841 router to a Cisco 2900 router

    My IT group bought me a 2900 series router to replace my 1841.  How do I copy the program from the 1841 and paste it to the 2900?  The reason for the change is due to needing more external ports.

    wyowool5 pointsBadges:
  • Stored procedure error in SQL Server 2008 R2

    I’m trying to change an existing stored procedure. I’m using the command: ALTER 'name_of_stored"procedure' When I do so, the name comes up with red highlighting, denoting that it is an invalid object. Although I am able to execute the command successfully, I want to know why SQL Server 2008 R2...

    ITKE342,970 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE342,970 pointsBadges:
  • Blaise Index

    what is this file and how do you open or delete it?

    Plippi5 pointsBadges:
  • *REGFAC in AS/400

    What is the use of keyword *REGFAC. When we create a new member and change the session defaults there is a option "user exit program" and in that option the above keyword is mentioned. What does it signify? What is the use of "user exit program?"

    Durgesh813370 pointsBadges:
  • Need to generate automatic IDs for SRSS Reports

    I am running almost 75 SSRS reports. IS there a way to assign a unique ID to each report? Is there a way to leverage system generated information somewhere in the SQL Server 2012 databases rather than manually assigning each report an ID, for example using spreadsheet?

    ITKE342,970 pointsBadges:
  • Difference between nvarchar(max) and NText

    Now, I'm a beginner using SQL Server and I'm looking to learn more about the advantages / disadvantages between "nvarchar(max)" and "NText" data types. Now, I don't need to know backward compatibility so I already know that "nvarchar(max)" isn't supported by previous SQL Server releases.

    ITKE342,970 pointsBadges:
  • CPF4326

    Hi all, I am reading data from a file PF1 using LF1 sequentially, and writing to other file PF2 using using LF2 using RPG Program R1. When I run it using CALL R1, it's working absolutely fine. But when use SBMJOB to submit it as batch job, it is going to MSGW. the error is: " CPF4326 occurred for...

    Sai4AS4001,420 pointsBadges:
  • Auto-increment in SQL Server 2008 R2

    I've just created a new table in SQL Server 2008 R2 and I'm trying to get the index on auto-increment. Is there a way to do this?

    ITKE342,970 pointsBadges:
  • How to store TOP 2 variables in SQL Server 2008?

    How can I make it so that I can store the top 2 results in 2 variables?create table t(id int); insert into t (id) values (1),(2),(3),(4); declare @id1 int declare @id2 int select top 2 @id1 = first id, @id2 = next id from tIs there a way to make this happen in one query without using a loop?

    ITKE342,970 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