• Get SMS jobs status in SQL Server 2014

    I have several SQL Agent jobs that are running on SQL Server 2014. Now, I need to get the SMS once a job has completed. This would include the job status and if went successfully through. How can I get that?

    ITKE1,011,475 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Set default value on SQL database table

    I have a SQL database that has a column with several tables. I need to create a trigger (or even a stored procedure) that would set the default value for the column in all these tables. How can I do that? Hope this question makes sense. Thanks.

    ITKE1,011,475 pointsBadges:
  • Mch0601 error rc 04 within SEQUEL

    Is there a SQL cleanup or reset command that I can run to avoid this space offset error? For some reason I can not run a particular sequence of SEQUEL commands. I have two separate applications. I have a script that creates a file, and then uses that file as a view. Then I have a report definition...

    Modiyooch760 pointsBadges:
  • Date field update using SQL

    I need to add 2 years to a date field using SQL.

    pugsgma10 pointsBadges:
  • Attach remote SQL database

    I have a SQL database that's stored on a remote server. Would I be able to attach it in SSMS? I tried to map it with a drive but that's not showing up as an option.

    ITKE1,011,475 pointsBadges:
  • Create new connection in SQL Developer

    I recently installed SQL Developer on my local machine. I noticed that no connections are appearing. How can I create a new connection? Is the first step to create a new database?

    ITKE1,011,475 pointsBadges:
  • Schedule a job in SQL

    I have no access to SQL Server Agent, am I able to get a SQL script run every morning 8am?

    SQL12345 pointsBadges:
  • What is the right way to write this SQL Query?

    I keep getting SYNTAX errors when I try to write this query, what is the proper way to write this query? Query question and table information is below. Return the last name and GPA of the top ten students by Cumulative GPA for students that were enrolled in at least one class during January 1,...

    dhay335 pointsBadges:
  • See SQL statements sent on ODBC connection

    We have an application that uses ODBC to connect (and possibly make changes) to our SQL database. But at the end of the day, the results are wrong. Because of that, we would like to see all of the SQL statements that were sent. Can we do that in ODBC? Thank you.

    ITKE1,011,475 pointsBadges:
  • SQL: Which part should I execute first in which manner?

    What should I execute first? proc sql; select distinct e.firstname, e.lastname from sasuser.flightschedule as sasuser.staffmaster as b, sasuser.payrollmaster as sasuser.supervisors as d, sasuser.staffmaster as e where a.date=’04mar2000’d and a.destination=’CPH’ and a.empid=b.empid and...

    kapil956365 pointsBadges:
  • Editing date field in SQL

    Can we edit date field in SQL select statement?

    Msatbh185 pointsBadges:
  • Converting DB2 Timestamp to UTC milliseconds

    I'll get right to my point - would I be able to convert my DB2 timestamp into UTC milliseconds? Is there a function to do this? And yes - I'm currently doing this in SQL.

    ITKE1,011,475 pointsBadges:
  • Dump content from IBM DB2 schema into SQL text file

    For the past few days, I've been trying to dump content from a schema (that's from a IBM DB2 server) into a SQL text file. But I'm running into a dead end. What should I do here? Is there anything like mysqldump for MySQL? Thank you.

    ITKE1,011,475 pointsBadges:
  • DB2 table columns description

    I'm using DB2 - I need to know the description of all the columns in my table. Can I do this using SQL? Thanks so much.

    ITKE1,011,475 pointsBadges:
  • Types of JOINs in SQL

    What are the types of JOINs in SQL?

    vijaykumar110 pointsBadges:
  • How to use Crystal Reports with LINQ to SQL

    I know this is a broad question but this is the only way I can ask the question. I use Crystal Reports all the time. Is there a way I can use that with LINQ to SQL? At least someone can point me in the right direction, right? Thanks.

    ITKE1,011,475 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • How do SQL related to this program?

    Can anyone tell me how SQL is related to my program?

    nlhabal5 pointsBadges:
  • SQL: Storing data in a column

    Sir, I want to know that in a table there are three columns like A, B, C. And I want to store the data on only A, B. When I insert the data, it automatically puts the result in C.

    Raju12345 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