• Triggers in sql server 2005

    hi Experts, I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields. Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields. Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and...

    Kmm0 pointsBadges:
  • Systems problem

    I always wonder why this happened to my system.....a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is......they notice that in no...

    Jdcruz10 pointsBadges:
  • Interesting Outout in SQL SERVER

    Folks, If I query like this, am getting the following Output.. Y is this so ??? SELECT 10_to_100 _to_100 ----------- 10 SELECT 25_from _from ----------- 25 If anybody is familiar with the reason, y the part of the data in select query getting truncated.. pls share... :) cheers ! ash

    Ashok tak0 pointsBadges:
  • SQL 2005 Restore DB with Multiple files in Primary File group

    Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

    Leeland0 pointsBadges:
  • VPN & CISCO 2610 setup

    Hello Sir/Madam, I cannot access our VPN from the internet outside our organization. I am using Cisco 2610 Router with IOS v12.3. And i created the access-list for the inbound and outbound connections. I have mentioned the access-list below and also i mapped a static IP address with the VPN...

    Parames0 pointsBadges:
  • Showing all records

    DATA SET: Table1 XID YID WRKDATE --- --- ------- 1 NOR 2007-01 2 SOU 2007-03 Table2 XID ZID QTY --- --- --- 1 PEN 10 1 PAP 20 2 PAP 5 1 PEN 10 2 PAP 5 Result XID YID WRKDATE ZID QTY --- --- ------- --- --- 1 NOR 2007-01 PAP 20 1 NOR 2007-01 PEN 10 1 NOR 2007-01 PEN 10 2 SOU 2007-03 PAP 5 2 SOU...

    TeamJR315 pointsBadges:
  • Report Properties Code

    Where can I find information on how to use the Report Properties Code

    JTHogan5 pointsBadges:
  • simple remote administration

    hey y'all... is there a way to do the following remotely? change passwords create a share on a server hard drive I have the adminpak installed on my workstation which allows me to do it. I want to be able to do it from ANY computer on the network. I have Win2k3 servers only, and WinXP clients only....

    TheVyrys0 pointsBadges:
  • Running Syantec Antivirus on a Windows Domain Controller

    I am currently in the process of deploying Symantec AntiVirus Corporate edition in my Windows-based network. In the manual it states, Do not install the primary management server on the following: Miscrosoft Exchange Server, Web server, or programs that prevent you from restarting the computer at...

    Skepticals0 pointsBadges:
  • R2

    does anyone know if windows server R2 is compatible with exchange 2003?

    Wolfden0 pointsBadges:
  • Exchange mailbox be backed-up

    Can an individual exchange mailbox be backed-up using the in-built Windows 2000 server backup utility?

    1111100 pointsBadges:
  • Issues in Replying or Formawarding Email Messages

    We are currently doing an Exchange migration from 5.5 to 2003 Exchange Server. Two of the user mailboxes that we have just moved have suddenly have issues replying or forwarding emails with or w/o attachments. They received the following error messages: John xxx on 4/26/2007 4:02 PM The e-mail...

    Sdr071515 pointsBadges:
  • crystal x1 ms sql ver. 7

    is crystal reports x1 compatible with ms sql version 7?

    Pbelgar5 pointsBadges:
  • how do i resolve two conflicting msde instances?

    I have installed a second application that uses msde (ms sql server 2000) but during installation the installer found an existing msde db. when I try to use the 2nd application, it tries to log on using a different password, unsuccessfully. Does anyone know how to create a seperate msde instance...

    Phil in Camas20 pointsBadges:
  • Odd Network Controller!

    My HP Compaq nx6110 was stollen last month but recovered by the police last weekend. My hard disk had been sold, so I got new one, but on reinstalling the system, the ethernet network adapter - which used to run with the Broadcom 4400 10/100 Drivers on the Application Recovery DVD - doesn't install...

    Lance010 pointsBadges:
  • How to create a user login and password in Enterprised Manager in SQL server 2000

    Hello, I am new SQL server DBA. I can create a new user. The request came in also ask for the password. Is there anyone can help me on how to set password to a user in in Enterprised Manager in SQL server 2000? Thanks,

    Tian81680 pointsBadges:
  • Question on JOIN Clause

    Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

    Ashok tak0 pointsBadges:
  • oracle quires

    while executing the following qurie 'inser into custmaster select * from tnjcust where seccode='431';' answer is not enough valus

    Balachander k0 pointsBadges:
  • How to write the query

    How to write the query from one table.(i don't want first row and second row)

    SQL Server0 pointsBadges:
  • Select from table where data row missing

    I have a table with the main fields being BU, ASSET, BOOK for any BU and ASSET combination, there should be two to four rows of data, with just the BOOK value being different. Data corruption has caused us to find all BU-ASSET combinations missing the value 'AMT' for BOOK. I need to join the table...

    Jej12160 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