• Restricting SQL Server database access

    We currently have a SQL Server that has roughly 50 databases. I need to create a login for one of our clients who needs access to one of the databases. Here's the catch: I don't want to give them access to any other database. Is there a way I can do this?

    ITKE435,940 pointsBadges:
  • How to get a constant value at specified potion

    Select count(*) as  Ltotal from tblLeaveRequest where ApplyingDate Between '2016-03-01' and '2016-03-05' group by ApplyingDate.

    nadini40 pointsBadges:
  • Adding Serial Number to an already existing access document

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

    Ansh12320 pointsBadges:
  • Backup error when restoring SQL Server database

    A few days ago, I backed up my database that I created on another machine (which was running SQL Server 2012 Express) and I need to restore it on my machine. However, I keep getting this error when I'm trying to do it: Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing...

    ITKE435,940 pointsBadges:
  • Need to port flat file data into AS/400 physical files

    Hi, There are some flat files in one environment (within the same AS/400) with huge data and we need to create physical files and need to port that data such that the reports being generated over those files should be same even after migration. Thanks in advance, Svanky

    svankipu625 pointsBadges:
  • Multiplying 2 fields from ASP.NET database

    How to multiply 2 fields from 2 tables from a database in ASP.NET?

    Srunaidu5 pointsBadges:
  • Admin access for Access Control Salto

    How do I gain admin access for Salto access control?

    DonnVl5 pointsBadges:
  • Which one is better to start career: Oracle DB or SAP Basis?

    Hi, this is shiva. Recently I got a job in a MNC company. I have a choice to choose domain Oracle DB or SAP Basis for 3 months training. Basically my background is Non IT. So little confusion which one to accept to start career as a beginner and better for future. I hope I will get answers as soon...

    singamsiva19935 pointsBadges:
  • Microsoft Access subform modification problem

    I have a main form with 6 tabs. I added a 7th tab and inputed a subform. However, when I rearrange the subform in design view, the edits do not show in form view. It appears I can only make changes to the subform when a I use the "Subforn in new window" button. With all my other subforms I can make...

    fjn0bu15 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:
  • Pass data from Access subform to another form

    In Access - How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

    Bdbarnes5 pointsBadges:
  • Script to connect to different database connection to export data into flat file

    Script to connect to different database connection to export data into flat file. I need combine data from different connections in system i navigator. I want to create a script to do so if it is possible. I'm new to system navigator.

    SQLinavigatoruser20 pointsBadges:
  • Dbase III files exported from Access

    In Access you can export data to a dbase III, dbase IV or dbase V file. However when I do this for a dbase III file and try and open it is dbase III plus software it says it is not a dbase III plus file. How can I open the file in dbase III plus? I could append it as a CSV file but I was hoping the...

    cornisht20 pointsBadges:
  • How to execute a message in PL/SQL from SQL command prompt

    Sir, I have written a small message using PL/SQL. When I execute that query in SQL CMD prompt, I'm unable to see my output. How can I execute my output in SQL?

    kothias5 pointsBadges:
  • What are the Advantages of database system over File processing systems?

    What are the Advantages of database system over File processing systems?

    Pepito5 pointsBadges:
  • The action will reset the current code in break mode?

    I have an Access mdb format split database. There are main form and pop-up subform. When I click on ID in main form pop-up subform appearing. This subform has 2 buttons to exit form without saving (Cancel, Exit).The problem is: When I filter records in main form by a certain ID, consequently, I...

    lissaru5 pointsBadges:
  • Access client’s WordPress database

    I scanned my customer's site for vulnerability in his site and I found the WP-CONFIG backup which contains all info about the site and database username and password. So how can I access my client's database using that username and password?

    mrchat5 pointsBadges:
  • Query pulling combo list box data

    I have a basic table in (column 1) list of individuals and in (column 2) lists the state(s) that the individuals hold licenses. Column 2 is a Combo Box Value List and several individuals hold multi state licenses. I am trying to figure how to pull out the states that require continuing education....

    emclean5 pointsBadges:
  • How to do a full outer JOIN in MySQL

    I'm fairly new to MySQL but I'm wondering if I could do a full outer Join in it? Does anyone know if that's possible? Is it actually supported?

    ITKE435,940 pointsBadges:
  • IIF function

    I have 2 tables: First table: 1- name 2- position 3- nationality 4- visa No. Second table: 1- Position 2- No of visas. 3- No of used visas. 4- No of remaining visas. But I want to use IIF function when add new position in first table increases the no of used visas in the second table automatically....

    khalid1155 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.

Thanks! We'll email you when relevant content is added and updated.

Following