• Open IT Forum: Does the Windows 8 secure boot and Linux clash affect you?

    We want to know how this "little" inconvenience is affecting the world of Linux users out there. Air your grievances or worries for the future of Linux right here, and we'll send you 50 Knowledge Points!

    MelanieYarbrough6,345 pointsBadges:
  • Setup SSIS for a group of developers.

    I newbie and I need help here. We are doing a new MS SQL and BI setup for our developers here. We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12...

    Cnboon5 pointsBadges:
  • 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:
  • Is there a way to find out when a patch was last applied to an instance?

    Is there a way to find out the date a SQL Server instance was last patched?  I need to keep track of dates each of my instances had a patch applied whether it be a security patch, hotfix or service pack.  I looked in the ServerProperty function but did not see anything that would return this...

    Mrhr246120 pointsBadges:
  • Parm Value Changed on Dynamic Call in free

    I have a prototype in my free program to call an external program. The parms on my prototype include two fields that are defined as 2S 0. The value of these two fields are 00 and 01 at the time of the call tothe prototype. Using debug, I step into the program being called and the value of these two...

    Canuhp235 pointsBadges:
  • Error Message in SQL Server 2008 code.

    Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr...

    JKJK45 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:
  • Return only one word– SQL

    Hello, I have a column called Profile in a table and I am searching for a specific word in that column. I use the keyword LIKE with the wildcard (%) and that is working fine, but how do I have the query only return that word and not all the text in the Profile column. For example, if an entry in...

    Ethanp5 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:
  • VERY slow server startup and shutdown

    Hi everybody! We have a problem on our Exchange 2003 server thats been getting worse and worse. We have a Dell PowerEdge 2850 server, and every time we try to shutdown or restart it, it take 10 to 20 minutes just to shut down and another 20 to startup. Sometimes we have to force shut it down...

    Shestopalov55 pointsBadges:
  • Insert values into database from form VB.NET

    Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want...

    Darthswift0040 pointsBadges:
  • user_change.sql

    in order to change the table names to the target system sid  after performing a restore of database from another system will the following code work --  -- Before running this script, replace the following[Br type="_moz" /> --    @NAME@       - your new <SID> in lowercase (prd for...

    Sudhakararaog5 pointsBadges:
  • Limiting SQL injection in SQL Server 2005

    I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

    SQL Server Ask the Experts2,585 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:
  • 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:
  • Using iSeries as linked server in SQL Server 2012 Express

    I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can't use the OLE DB2 extension from Microsoft since it doesn't work on SQL Server Express. So, I figured out (with Google's help) that I could run this script to...

    Koohiisan5,020 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • Matching key question – resubmitted

    Hi, resubmitting because the first upload did not seem to work... Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3...) Col2 has letters...

    Slowlearner25 pointsBadges:
  • Temporary Internet Files ( long file names – can’t delete )

    I have come across a few files on several computers that have files with long names in the temporary internet files folder. The files can not be renamed or deleted. Has anyone come across this problem before and if you have, Please let me know what worked for you. I have tried deleting the files...

    Sheldonrw0 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