• Error message when restoring a SQL Server database

    This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Posting Data Online

    We want to "post" various documents on-line so that we can give members of our outside consulting group access to view, and even possibly download them. Is it possible without opening them up to the public-at-large? In answering, keep in mind the following: 1. We prefer not to purchase any...

    TheVyrys0 pointsBadges:
  • Sharepoint 2010 x64 central administration problem http error:503. The service is unavible

    Hi. I installed Sharepoint 2010 x 64 version. My sql server is Sqlserver 2005 + Sp3+ hotfix. I confingured sharepoint central administration with NTLM. When i tryed open central administration it gives me Service Unavailable   HTTP Error 503> the service is Unavailable . My operating System...

    Eliyevelxan1,235 pointsBadges:
  • Can anyone suggest a good loan APR formula in SQL

    I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?

    Nrate5 pointsBadges:
  • Changing the computer name?

    Hi, How can I change the computer name without disjounting computer from the domaim(win xp pro sp2)!? Thank you. --- Regards Mahnaz

    Aliyani265 pointsBadges:
  • Connection of VB6 with SQL Server 2000

    I want to connect VB6 application with SQL SErver database such that if anything is saved in VB6 forms it will be saved in the database tables of SQL Server.

    Jayee5 pointsBadges:
  • File Level Identifiers

    If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?

    Kevkel5 pointsBadges:
  • Open IT Forum: What are your views on social networking platforms in your network?

    I chatted with David Sacks, CEO of Yammer, last week at Enterprise 2.0, and we talked about IT's changing attitude toward cloud-based offerings such as social networking platforms. I'd love to hear from practicing IT professionals about the impact of these platforms on the network, whether it's...

    MelanieYarbrough6,345 pointsBadges:
  • VNC over Broadband/internet

    Hi all, My IP skills are somewhat rusty - could someone please help me with some high-level steps to remote control using VNC over the internet... scenario: Customer down the road is always requiring assistance - usually I need to jump in the car & go there to sort out the latest dilemma. I'd like...

    SCOOBAMAN0 pointsBadges:
  • Validating Active Directory login from within a stored-procedure

    I have an application that needs to use active directory to ensure user login is valid. The issue is that the machine is in a different domain than our AD server. I am looking at creating a clr procedure on the SQL server that is in the same domain. Then from the application execute a procedure...

    Joetig35 pointsBadges:
  • Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command

    i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

    Mdshadabalam85 pointsBadges:
  • Trustworthy Self-study material for SQL Server and Oracle

    As a novice, I am seeking advice regarding the best (trustworthy) self-study material for Microsoft Sql server or Oracle exams and that would teach me what I need to know for training.

    RLT5 pointsBadges:
  • Open IT Forum: Are you on hacking offense or defense?

    Sony isn''t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin's breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company's security has been compromised in the past, how did you respond and set...

    MelanieYarbrough6,345 pointsBadges:
  • Optimize SQL 2005 databases on a schedule

    How can I optimize my SQL 2005 databases on a schedule?

    NewnanIT1,110 pointsBadges:
  • Search: Error with SQL : Login failed for ‘SA’.

    I'm using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I've been having the following error anytime a call for a screen in the software"Search: Error with SQL : Login failed...

    PrinceBismark25 pointsBadges:
  • SQL Server Patch

    How do you get notified when Microsoft is doing a SQL Server Patch? Is there a way to be alerted before they do a patch?

    Amfaust15 pointsBadges:
  • Can you use variables as input and output when calling a stored procedure in COBOL?

    If you move data into your variable before calling your procedure, can the procedure then return a value back, which might be different? The procedure will intially be searching for the variable data, but, according to our .net programmer, will return a blank or null if it does not find the data....

    Bunkyg15 pointsBadges:
  • Free IT Book: Securing SQL Server

    This week's free IT book is written by one of IT Knowledge Exchange's very own members, Mrdenny. Securing SQL Server promises to help you "secure your SQL Server database so the outside world can't access your internal data." With Mrdenny's extended experience in simplifying SQL speak via his blog,...

    MelanieYarbrough6,345 pointsBadges:
  • SQL code made simpler

    I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat. I got the...

    PSMurray530 pointsBadges:
  • System tables in SQL Server

    How to view System tables in drop down menu of a database in SQL SERVER 2005

    VendoorMohankrishna5 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