• Halt audit trace if audit file doesn’t rollover

    I have a security requirement for SQL Server 2005 and 2008: "SQL Server shall be configured to halt if a failure in audit file rollover occurs". How do I accomplish this?

    VelameLaCosa110 pointsBadges:
  • Free IT Book: IP Networking

    We're giving away a detailed and practical overview of TCP/IP networking in IP Networking. From the publishers: "IP Networking takes you from a broad and basic knowledge of IP addressing and routing to a solid skill level with how hosts, switches, and routers collectively deliver IP packets in...

    MelanieYarbrough6,345 pointsBadges:
  • MYSQL database high availability

    I have cent os based LAMP system. My question is that, what is the best way to make mysql database high availability. As per me database clustering is a good option can you please suggest me.

    Chetanm145 pointsBadges:
  • How can do iSQl*Plus login for DBA

    I want to create iSQL*Plus login for DBA. How can i do this ?

    MelanieYarbrough6,345 pointsBadges:
  • Wireless network set up best practices

    Our open office space is specifically 75M long & 21M wide with 2 Access Points.  Kindly note we have raised floors made of formica(height from raised floor to ceiling=8.3M) and Partitioned offices with boards made of fiber. Is it proper to install 2 APs(Linksys) with a distance of 7M...

    Wilsona5 pointsBadges:
  • EXTENDED: IT Scripts Contest now ends October 17

    It's not too late! IT Knowledge Exchange is extending its latest contest: Is your script 3-dimensional? You don't have to be an IT Script Shakespeare to get in on the contest: Did you know you can win a Nintendo 3DS for just leaving a great comment on one of the entries? Check out the entries under...

    MelanieYarbrough6,345 pointsBadges:
  • Track SQL Statements run by a specific user through ODBC Connection

    There is a user id connecting to our iSeries System through ODBC Connection and will be executing some selected queries on iSeries using a 3rd Party Application. Those selected queries are approved by the Application Owner. Hence we would like to track the SQL Statements which are executed by this...

    Haaiderali215 pointsBadges:
  • For Do rename loop

    Would anyone know of a createive way to change the following to represent a "do ren" loop and cleanup some of the un-needed syntax? for /f "tokens=1-9 delims=/ " %%d in ("%date%") do ren "A B C *.xlsx" "A B C %%e %%f %%g.xlsx" for /f "tokens=1-9 delims=/ " %%d in ("%date%") do ren "D E F *.xlsx" "D...

    ConFlicker210 pointsBadges:
  • Select substring from clob-field with sql

    How do you copy substring from clob-field with SQL if substring from/to positions are varables? This works OK (RPG free w embedded sql): exec sql select substr(myclobfield, 25, 70)                 INTO :mystring                 FROM MYLIB/MYFILE; [/pre] Whereas this...

    DanTheDane2,555 pointsBadges:
  • copying tables to excel

    How do I copy a table with more than 65000 records into an excel workbook?

    DatamanWarwick5 pointsBadges:
  • Creating Views in MYSQL via Sysdate

    Hello Guys, I can create simple views for MYSQL Database tables but I am unsure on how to create a view for the following requirement: I want to create a view which restricts staff user access to a specific table between working hours of 13:00 - 14:00. I have been told that this can be implemented...

    Help1235 pointsBadges:
  • MS SQL query to update a table with the last entry in another table.

    Hi, Could anyone please assist. I'm trying to update a Reporting Table with the last entry in another table. I've tried to arrange the table according to the ID row. This works great. Then the query to get the last entry woks as well, but to get the two to work together and update the table is a...

    GPNel200675 pointsBadges:
  • Access 2003 SQL Query for grouping

    Team... I need your help... SELECT Pickerid, Sum(Currentweight) AS TotalWeight, IIf(pickerhours=0,0,TotalWeight/pickerhours) FROM mergeddatabase WHERE ((Currentdate) between [Enter First Date Required:] and [Enter Last Date Required:]) GROUP BY pickerid, pickerhours; I have a access database (2003)...

    witsendestate225 pointsBadges:
  • I would like to run a report on AS/400 to indentify which DB2 tables to reorg.

    Hi,  New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a utility...

    WendyB95 pointsBadges:
  • vb.net 2008 login using ms access

    hi guys,ive been working on trying to create a login form. ms Access side: -used a logininfo.mdb database with columns :username,password,job vb 2008 side: -login form with clerk rad button,manager rad button,username text box,password textbox and login button now the challenge im having is that...

    Dissector5 pointsBadges:
  • OLE object

    The Access form will not accept olebound .jpg pictures. The form is referencing a table with an OLE Object field definition. The picture frame on the form is created using OLEbound object frame. When using Insert Object' and finding the file containing the .jpg picture, only the jpg tag and the...

    Bocaj735 pointsBadges:
  • override database and logical file

    what the main difference between OVRDBF override database in CL and logical file... which one have most advantage...

    pdsathishkumar3,790 pointsBadges:
  • Problem converting numeric to date data type

    I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql...It giving error ..please help me out ..I tried using date and cast function but its not working !!

    munduuu435 pointsBadges:
  • AS400 – SQLRPGLE

    Hi, We are moving Values to Database Fields using Embedded SQL Concept. In Embedded SQL, We can decide the Variable Names dynamically. Is it possible with Display File? why?

    rajeshece1,215 pointsBadges:
  • Download AS400 Physical File to Excel Using VBA

    I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain...

    Martyjw5 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