• Will the use of LTRIMs and RTRIMs in Stored Procedures improve performance, instead of using them in Triggers?

    Hi All, I have a job running in SQL Server 2000. I have defined triggers on some tables. I have used LTRIMs and RTRIMs in my triggers. Now, there is a performance issue in my job. Its taking a lot amount of time for successful completion. I have been suggested to trim the data while inserting or...

    Bakash0 pointsBadges:
  • Data Integration

    We are in the beginning stages of integrating data between a PC based inventory system and the iSeries. Specifically we will be downloading and uploading data between the two systems automatically. We have had success using ODBC. We also need to be able to call an RPG program from the PC based...

    Christina0 pointsBadges:
  • Remote Downlevel Document and .spl files

    I have been beating my head for the last 5-6 hours, trying to find anyone similar to my problem, but I haven't had much luck. I am having a problem with .SPL files with 0 bytes filling up my spooler directory. These files don't appear all the time, just periodically. But, because I have 700+ users...

    KeithD19670 pointsBadges:
  • SQL Server Slowdown

    I'm running SQL Server 2000 with Windows 2000 Server on a Xeon multiprocessor system with 3 GB RAM. We've been experiencing slowdown and excessive CPU utilization of system processes with very little user activity. Upon our investigation of the CPU utilization by kernel - using the Kernrate Viewer,...

    Rkeister0 pointsBadges:
  • Using Query returned values in Oracle Graphics 6i

    Hi all, I wrote a query in Oracle Graphics Builder (6i)(Bar Graph). The query will return diff. categories(so multiple bars) wherein each category will contain atleast one subcategory(Maximum three). So, each bar will contain either one or all the three sub-categories. My requierement is to set the...

    Mphani0 pointsBadges:
  • Permissions problems

    I have the strangest problem - I have set permissions in AD (Server 2000/2003 - Exchange 2000)for one of our users to have full rights to send e-mail as her immediate supervisor. This was working fine until about 2 weeks ago, all of the sudden she started getting NDR's that she doesn't have...

    Shellygrez0 pointsBadges:
  • AD domain name in the domain logon dialog.

    Hi, I have upgraded my NT4 domain (NTdomain) to AD recently (domain.companyname.com). All works perfectly the only concern is that the client machines got 'old' domain name but no new FGDN in the login screen. Is there any way to have AD (DNS) domain name there on the drop down list? or the logon...

    JakubK0 pointsBadges:
  • SQL Server 2005 adoption

    My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to...

    Nbellistri0 pointsBadges:
  • Stop bit problem: USB to Serial Converter attached to motion controller, unable to set for 7-E-2

    I have three different USB to Serial converters, one of them an isolated converter from B&B. One brand of motion controller I work on uses EVEN parity / 7 data bits / 2 stop bits as its default. I find that none of my converters will work on the controller in this configuration. If I borrow a PC...

    Kfink040 pointsBadges:
  • Microsoft job interview question – what is the best “right” answer?

    Posted on behalf of WhatIs.com member Michael B.: Suppose you go home, enter your house/apartment, hit the light switch, and nothing happens - no light floods the room. What exactly, in order, are the steps you would take in determining what the problem was?

    Margaret Rouse1,730 pointsBadges:
  • SPAM

    I am running Exchange 2003 and Win2k3 servers. we get a ton of spam, and I want to stop it. What in your opinion are the best SPAM softwares and why? (such as strong points and weak points) let's hear it....

    TheVyrys0 pointsBadges:
  • Changing the owner of a view

    How do I change the owner of a view? I have tried using sp_changeobjectowner which fails because the dependant table is owned by the same user that I'm tring to change the view to. Do I really need to drop and recreate the view? If I attempt to update the uid in sysobjects I get a message claiming...

    Adams10050 pointsBadges:
  • Active Directory

    Dos anyone know of a way to search Active Directory for an email address? When I go to add a particular email address to a group, AD says that the address already exists and can't be used again. I can search Users for email addresses, but not Groups...

    EdTurbo0 pointsBadges:
  • MS Access to SQL Server Image

    I have a Sql Server 2000 database. We don't have Web resources available, so I must write a User Interface in MS Access 2003. What I want to do is have the user supply a path and name for a document. Then I want to load the document into the Image field of the SQL Server DB. I have found some code...

    DonMonroe0 pointsBadges:
  • Upgrade step from win nt and win 2000 to win 2003

    I have windowsNT and window 2000 servers with active directory which i want to upgrade to windows 2003,all servers meet requirement for new vesion.Now can same help me on how to upgrade?what steps should i take

    Eduado0 pointsBadges:
  • Changing out PDC’s and rolls

    We are upgrading our servers and will be replacing our PDC if a new server ? we have two domains and we will be replacing the PDC in both domains. Can some point me in the right direction as to the best way to do this with no down time. Once we have the new servers up and running smoothly as PDC?s...

    J4boat0 pointsBadges:
  • SQL Server database was succesfully restored, but its replication state is indeterminate

    I tried to restore the a SQL server database to a different server from a backup. I restored it on two servers unsuccessfully. The following are the messages displayed after the restore: The database was succesfully restored, but its replication state is indeterminate (This is odd because the...

    SQLDBA540 pointsBadges:
  • Difference between Subdomain and Childdomain

    Hi What is the difference between Subdomain and childdomain. If possible give one reason. Thanks in advance. Manjunatha Reddy

    1500000 pointsBadges:
  • export sql server to iseries files

    when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can't find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is not found Any suggestions

    AS400programmer0 pointsBadges:
  • Triggers in SQL SERVER

    Hai everybody, this is my first query to this datacenter. pblm is i need to write a trigger in sql server which should fire automatically everyday at a particular time say 9.30 am. once again iam remainding its to be written in sql server. also whts the equivalent operation of logon event and...

    Carbuncle0 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