• SQL Server 2000/2005 – Creating Unique Constraints allowing multiple NULLs

    Hi there! I'm having a problem maintaining data integrity on a database table in MS SQL-Server 2000. To ensure maintaining the integrity I need to implement a Unique Constraint on one of my coloumns. The problem however is, that this coloumn also has to allow multiple NULL-values - but for every...

    LeChuck0 pointsBadges:
  • Is a Microsoft certified database administrator (MSDBA) certification course good with my SQL Server experience?

    I am working in a data migration team on SQL Server. I am planning to do the Microsoft certified database administrator (MSDBA) course. Please let me know if this certification matches with the line of work I am doing, or if there is a more preferable certification that would contribute to my SQL...

    NetworkingATE1,545 pointsBadges:
  • Running SSIS on a clustered server with SQL Server 2005

    We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server with Active/Passive 'A' and 'B' nodes. Databases are on a shared LUN. I can run all my SQL Server Integration Services packages on the 'A' node with no problem. When we fail over to the 'B' node, though, packages are failing....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sql Server Linked Server to iSeries

    Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on which...

    Technet30 pointsBadges:
  • SQL Server Profiler returns incorrect hostname

    We are using third party (Idera) software for auditing activity on our SQL Servers (2000) and some of the events collected do not contain correct data. Idera SQL Compliance Manager uses Profiler to generate trace files which it then parses elsewhere. Idera suggests that the problem lies outside of...

    Boreal0 pointsBadges:
  • Window versus Unix?

    please advice : Window Vs Unix please tell me why unix not window  or why windows not unix

    Mohaned1st15 pointsBadges:
  • How can I Install Lotus SmartSuite on Windows Vista?

    How can I install Lotus SmartSuite on Windows Vista 32 bits? I got "Error accessing the registry" message when I try to install it.

    Asunten15 pointsBadges:
  • Domino Initialize The System cannot find the file specified

    When I initialize a Domino session in Microsoft Access VBA (2003) running on Win7 box I get "The system cannot find the file specified" error. After ok is clicked the process succeeds anyway. Same code ran fine on Windows XP. This is Lotus Notes 7. If Lotus Notes is running, I do not get the error.

    UPSFreight5 pointsBadges:
  • Steps to install oracle 8 on windows 7

    What are the steps to install Oracle 8 on Windows 7?

    saabil15 pointsBadges:
  • Adding Destop Shortcut and icon using GPO

    Hello, I’m hoping someone out here can assist me. Currently the users in my domain have a link in their IE favorites that is populated using Group Policy. Senior management would like this particular link to be placed on all users desktops as a shortcut along with a specific icon. I’ve copied...

    Crphgoldstein5 pointsBadges:
  • What is the most efficient way to implement pagination in SQL Server 2008?

    I am trying to find the most efficient way to implement paging within SQL Server 2008, using ASP.NET MVC and LINQ. Should I use LINQ's Skip() and Take()or implement my own pagination with a SQL query?

    Chris Leonard4,300 pointsBadges:
  • We have one AS/400 printer of HP model

    We have one AS/400 printer of HP model, its printing first print and then stopping, every time we have to start the printer. Can you please suggest why this is happening, and how can we fix this.

    anusuiyasingh5 pointsBadges:
  • What does this controller error mean?

    I have an HP Pavilion Laptop running Windows 7. I recently discovered an error in the Event Viewer: The driver detected a controller error on DeviceIdeIdePort1. (more details): - System - Provider [ Name] atapi - EventID 11 [ Qualifiers] 49156 Level 2 Task 0 Keywords 0x80000000000000 - TimeCreated...

    ITKE342,240 pointsBadges:
  • Uninstalling SQL Server 2008 R2 manually

    When I'm using my Windows 7 Ultimate x64, I honestly can't do anything with the existing instance of my SQL Server 2008 R2. I made the mistake of uninstalling some requirements related to SQL Server before running the main uninstaller.It seems like the uninstaller is doing its job (it's saying all...

    ITKE342,240 pointsBadges:
  • RTF

    Can I save files in RTF in Vista 2007?

    eillien5 pointsBadges:
  • How to disable command prompt for non-admins on windows 2003?

    My environment has a requirement that the command prompt be disabled for any non-administrator users. This is easy to do in Windows 2008 with a local policy via the MMC, as per instructions from maxvre here: http://www.edugeek.net/forums/windows-7/67055-blocking-command-prompt. I cannot figure out...

    codger1015 pointsBadges:
  • Pagination via Entity Framework and SQL Server 2012

    I’d like to use Entity Framework 5 to change pages using Take + Skip. I’ve heard that SQL Server 2012 provides a better way for paging using FETCH and OFFSET which could have a big impact on performance. Does Entity Framework 5 support this? Will the LINQ queries be translated into the new 2012...

    ITKE342,240 pointsBadges:
  • Win 7 file displayed as read only

    Win 7 computer A(W7-A) has many folders and files set as read/write for everyone. W7-B and W7-C will get message periodically that says files are read only and in use someone else when they are not opened by anyone. All computers are the same workgroup. All are Windows 7 Pro Running. W7-B is...

    DennysCS10 pointsBadges:
  • P2V migration of Windows server 2000 (no shadow copy service)

    I wanted to perform a quick P2V migration of an old Server 2000 box that runs a couple of undocumented automated processes like file transfers. P2V utilities like Disk2VHD utilize the Shadow copy services within windows and the copy process fails because VSS is not available in server 2000. We're...

    slack4002,705 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE342,240 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