• Joining computer to the domain and adding computer to specific OU

    Hi, all! Usually when you join computer to the domain, the account of this computer is created in Computers container. I have a remote office and OU of this office in AD. That office has a local system administrator. He should be able to join computers in his office to the domain. I've gave him a...

    Ralfeus0 pointsBadges:
  • Calling a stored procedure on a remote server using embedded SQL in a RPGLE program

    I have written a RPGLE program in which I access a remote SQL server and then call a stored procedure on this SQL server. There are no parameters. I just call the stored procedure using embedded SQL in my RPG program. The program comes back with a -204 error code. It almost seems as if it cannot...

    GHENDER200 pointsBadges:
  • How do you increase the primary partion size in Win2K Pro

    I am running into space issues on a Win2K Pro desktop. How can I expand the primary partion (C: drive) to utilize unused space on another drive (on the same physical disk)? I do also have a second physical disk with space available if a solution exists using that option. Could I solve the space...

    Anannymouse0 pointsBadges:
  • MSSQL 2000 – ODBC connection SQL state 28000 error 18456

    I am trying to make an ODBC connection to a MSSQL 2K server on a remote machine. I am using the SQL Server driver and can see the server in the drop down list when asked which server I would like to connect to. I am using SQL authentication over TCP/IP. The error occurs when ODBC tries to connect...

    Seldom0 pointsBadges:
  • Group Policy – adding shortcut to all users desktop

    I am a complete novice to group policy, so if you answer, please take me step by step. I would like to use Group Policy to add a IE shortcut to "all users - desktop". How exactly do I do this? Thanks!

    Gforsythe75 pointsBadges:
  • IBMDA400 Provider & SQL 2008 select statement issue

    Using IBMDA400 as a provider on SQL 2008 server then a link server object. In the studio when I ask it to create a select statement for a table the numeric columns are not included. I can do Select * and all fields are included and the query works fine or I can simply add the numeric fields to the...

    Peteakers45 pointsBadges:
  • Access Outlook express in home computer

    I set it up a new computer in my home office (connected via cable modem), and also want to access the program from the downstairs computer (wireless connection). The problem is some incoming emails show up on the office program and others show up on the downstairs machine (I think when the...

    Jujugiants0 pointsBadges:
  • SQL query help – SQL Server

    Okay, I hope I can explain my dilemma... I need a SQL select statement that will Select part_number from RCTOOL the column part_number has values such as BR643-0034-344-34 AS54-54689 A77360-3454-34456-4 B7374-343-33-32-356-433-11-1 In each of these cases ALL we want it to return is the values UP to...

    MyDanes35 pointsBadges:
  • SQL server 2005 and 2008 needed on same network. Same machine or seperated?

    Hello there, I have to install both SQL server 2005 and SQL server 2008 in order to use CRM software and a financial software. After chatting with the financial software support & the CRM guys I understood I have to have both versions on my network since each needs its own version of SQL server...

    abmolibenny10 pointsBadges:
  • Desktop lockdown

    Hi all, I have 30+ windows 2000 clients running of a NT4 Server. The clients are locked down via gpedit but due to teacher requirements need the right click enabled. What i want to do is either: Stop any changes to desktop, or set a default wallpaper that cannot be changed. We have no money despite...

    Carl0s810 pointsBadges:
  • SSIS, CLR, sp_OAMethod or another method to call web method

    I have a question on which method is the best practice. I have been given a task to run a web service method every 5 minutes. There is one input parameter and no output to return. The service runs a bunch of functions to do data validation and then inserts into a DB2 database. (could not get a...

    ToddN200021,300 pointsBadges:
  • IBM Linked server will not do inserts

    I've spent close to 2 days looking for an answer and only got a headache. We have our IBM DB2 linked server defined as IBM DB2 UDB for iSeries OLE DB Provider. We can run select, update and deletes we just cannot do an insert. Here are our sample statements. SELECT * FROM OPENQUERY(OUR_DB2,'SELECT...

    ToddN200021,300 pointsBadges:
  • SQL Server Management Studio Restrict Access

    Is there anyway to add restrictions to the Object Explorer in SQL Server Management Studio to prevent Table objects being expanded? And is this something that can be added to the sa account or would I need to add a new account for this?

    Darraca290 pointsBadges:
  • SQL and T-SQL

    If you are used to programming in SQL, will there be any issues with switching to T-SQL?

    lprice230615 pointsBadges:
  • SQL Server 2008 R2 replication

    Good Day. I configure Transactional Replication using SQL Authentication. The subscription account was added to the PAL and it belongs to the Sysadmin group and database_owner role. When I clicked on the VIEW SUBSCRIPTION STATUS and the result shows that the synchronization is working. I also...

    ABSA5 pointsBadges:
  • SQL system date

    I have a beginner SQL question. I'm new to using SQL on the iSeries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...

    RonKoontz1,780 pointsBadges:
  • Download VB, Oracle and Java

    Can I download VB, Oracle and Java for my practice?

    Kiaskala10 pointsBadges:
  • Setting up SQL Server 2005 memory

    My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set 'lock page on memory', but Task Manager show only 4.50GB only and performance monitor show SQL server manager - total memory on 4GB. Expert: Do I setup memory wrong?

    Maylee6330 pointsBadges:
  • SQL Server 2005 memory issue

    SQL server 2005 running on Windows XP. The memory grows steadily then SQL (system) hangs when memory gets to 1.7 GB and then the server must be re-started. What could cause this?

    Uphs25 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 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