• How to read transaction log in SQL Server 2014?

    I need access to the read transaction log file in SQL Server 2014 for auditing purposes. In the past, I’ve used a third party log reader, but we’re looking to cut costs. I’m familiar with CDC, but that only allows access to data changes and I also need access to schema. Is there an improved...

    ITKE346,360 pointsBadges:
  • How to view transaction logs in SQL Server 2014?

    Hi, I have SQL Server 2014 CTP 1 installed and I can’t figure out how to view all transaction logs.Does anyone know where I can find them? I’ve looked at datasheets and documentation on MS website but I couldn’t find anything.

    ITKE346,360 pointsBadges:
  • I keep receiving an error in SQL Management Studio

    When I'm trying to create several users in SQL Management Studio, I first create them under the server name, followed by the database. However, when I'm trying to log on, I keep getting this error message: A connection was successfully established with the server, but then an error occurred during...

    ITKE346,360 pointsBadges:
  • Does SQL Server 2008 R2 Express have Intellisense?

    Is Intellisense available in SQL Server 2008 R2 Express Management Studio? It seems like it should be there. Is it inactive or am I doing something foolish?

    ITKE346,360 pointsBadges:
  • SQL Server configuration

    How would I configure SQL Server 2008 R2 to handle 1 million connections?

    ETCGMan40 pointsBadges:
  • Grouping of a/c.

    I am using Oracle and through SQL Worksheet i want to get information as followes.  My table Name is bilmst and field 1 enterdate and field 2 a/c. no  I want to group no of a/cs fininacial year wise. My financial year starts from 01-jul to 30-jun for example 2005-06 means from 01-jul-05 to 30-...

    23523523595 pointsBadges:
  • convert SQL datetime to date only

    Using SQL, how can I convert a data in a datetime field to a date only data? When I run a job to collect data, I use the getdate() function that returns the date and time. I want to then convert this to the same date but with a time of 00:00:00. Please advise. Thanks! ~Gina

    Gina35 pointsBadges:
  • Encrypt a Column in SQL Server 2005

    I'm trying to encrypt a column. Unfortunately I don't have access to the C# source code that is accessing the data. All the instructions I've found require me to use the decrypt function in my SQL command. How do I automatically encrypt and decrypt without being able to change the source code? Is...

    Jfw10075 pointsBadges:
  • Store image from a directory into Oracle database using SQL

    I have a directory containing 1000s of photos which I have to upload into Oracle 9i DB. I need to use only SQL plus for this. I want a simple material to upload all those photos.

    cmuraz5 pointsBadges:
  • SQL optimization in COBOL400

    I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch? The file has key as date. My sql would look like Delete from FileA where Date < 'some date'

    anuppdas105 pointsBadges:
  • Setting column limit entries in SQL

    Hi I need to expand the column limit entry in SQL. Can anyone help? Example: defauld column limit is 1032. I would like to expand it to 5000. I will appreciate any help. Thanks!

    Ctc12320 pointsBadges:
  • Trying to use “Transfer data from iSeries add-on to Excel

    I am trying to use 'Transfer data from iSeries' add-on from within Excel. I have specified my library/file as : <><><><><><><> TANFILE/NCUFFLDR Data Option as: Select NCUFFLDR_COMPANY_TYPE Where (NCUFFLDR_COMPANY_TYPE=M)...

    CasNowak0 pointsBadges:
  • Difference between Structured Query and Query in AS/400?

    We used STRSQL- FOR START SQL(Structured Query Language) and STRQRY- FOR START QUERY. What is the difference between Structured Query and Query? (SQL and QRY)

    anupsshelke420 pointsBadges:
  • Difference between SQL Server 7 & SQL Server 2000

    Hi, Can you tell me difference between SQL Server 7 and SQL Server 2000?

    Marshal0 pointsBadges:
  • How to write SQLRPGLE query with many select criteria

    I have a report to print using SQLRPGLE. The Report criteria screen has around 15-20 select conditions. Based on the conditions entered by the user, I build a query of type: Select * from emp1 where val1 = ? and val2 =? and val3 = ? and........... This is the first time I'm dealing with so many...

    Nutangujar895 pointsBadges:
  • SQL query to find out policy numbers

    There are 2 tables POLICY and NAME. The relationship between POLICY and NAME is only the policy number. and their relationship is like many to one. I mean several policy numbers can have same name in the name table with that many records. Now my question is to find out the policy numbers having the...

    Deyyam0 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Error message CPF4326 appeared during OPEN for file EMPJ1 (C S D F). .

    Hi, I am getting the error below. What is this error...please explain it to me. Message ID . . . . . . : RNQ1216 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . : 08/18/13 Time sent . . . . . . : 14:11:56 Message . . . . : Error message CPF4326 appeared during...

    Jay1010 pointsBadges:
  • SQLEVN70.RLL

    How do you uninstall then re-run/install SQLEVN70.RLL on a IBM M/T 8104-C10 S/NL3RF550?

    2rick15 pointsBadges:
  • Data Conversion on IBM AS/400

    Hi, We're converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files...

    DataConversion0 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