• Records with null value not in output

    See query: select distinct f2.description Business_Unit, f3.description Department, f4.description Function, a.segment5 Account, f5.description Account_Description, sum(nvl(d.entered_dr,0) - nvl(d.entered_cr,0)) Actual, (Select sum(nvl(dd.entered_dr,0) - nvl(dd.entered_cr,0)) from...

    Tams5 pointsBadges:
  • SQL Subfile and position to ability

    I have a subfile that can be sorted by any of 4 fields, so I want to use imbedded SQL to read the data out of my PF in order to populate the subfile. I want to be able to allow the user to enter position to information, and position to that entry - normally, I would do a SETLL to the file based on...

    Klw50 pointsBadges:
  • Executing System Stored Procedures

    What kind of "Permissions" does a developer need in order to execute sp_fulltext_catalog, sp_fulltext_column, sp_fulltext_database, sp_fulltext_table, sp_addLinkedServer, sp_addLinkedSRVlogin ?

    VelameLaCosa110 pointsBadges:
  • Can’t Upgrade to SQL Server 2005

    I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so it...

    Randym1,740 pointsBadges:
  • List the names and addresses of all employees who are Mangers

    Employee (emplD, fName, lName, address, DOB, sex, position, deptNo*) Department (deptNo, deptName, mgrEmplD*) Project (projNo, projName, deptNo*) WorksOn (emplD* projNo*, hoursWorked) where Employee contains employee details and emplD is the key. Department contains department details and deptNo is...

    Shawe10 pointsBadges:
  • I need to move a sql 7.0 database to a different server running sql 2005.

    What would be the best way to do that and will the jobs and DTS jobs come with the database? If not how can I move them also. Thanks for any suggestions.

    Bubbanm90 pointsBadges:
  • Receiving an error in Quality Assurance on SQL Server 2005

    I am trying to run the following command in Quality Assurance on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Do you have...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copying a database from SQL Server 2000 to SQL Server 2005

    I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring SA access to SQL Server

    I have somehow removed my SA permissions from my SQL server. I do not know the SQL SA password. Is there any other way to restore my SA access to SQL? I am a local admin on this server.

    SQL Server Ask the Experts2,585 pointsBadges:
  • write multiple images from SQL database using response.binarywrite

    It seems I am able to write a single image with the following code: ID1 = replace(request("ID1"), "'", "''") Dim connStr connStr = Application("DSNFPT") Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "select [Image],[ContentType] from FPT_Images where ID = " & int(ID1) & " order by...

    Tacopants5 pointsBadges:
  • Error messages during the creation of a mirror database on SQL Server

    I am trying to restore a database from one SQL Server to another to create a mirror database. However, when I enter “RESTORE DBMirror FROM DISK=’C:Backup DBMirror_FULL.BAK’ WITH NORECOVERY,” next to the database name appears the error message “Restoring…” It never goes away. What...

    SQL Server Ask the Experts2,585 pointsBadges:
  • problem with sys.endpoints

    Hi, I have ms sql database created in 7.0; I had shift all the data files to a different server where ms sql 2005 is installed. I was able to start sql server from the 7.0 database by specifying the startup parameters. But when I try to connect thru sql mgmt. studio I am getting the "object not...

    Vsskmk5 pointsBadges:
  • db backup

    why does sql bu returns a time out

    Stanja10 pointsBadges:
  • SQL client number

    If I have 500 clients in an environment, does that mean I need 20 servers with SQL 2005 Enterprise--each with only 25 client availability?

    Cnotejunebug20 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005

    Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

    ITHULK10 pointsBadges:
  • Viewing created stored procedures in SQL Server

    How can I view stored procedures that have already been created in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Catching blocks using a stored procedure in SQL

    I have a stored procedure in SQL that I use to catch blocks. This stored procedure is executed by a stored procedure higher up. How do I relay the error info, if there is error info, to the parent? Do I need to use a return code or is the error info just passed back, no matter what?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating shell scripts

    We have to move more than 250 shell scripts from a unix to a linux environment, and also 100 sql scripts. Could you please give me some steps or a check list to follow to migrate these from unix to linux?

    Chunter110 pointsBadges:
  • Giving login and database permissions to a group in SQL Server 2005

    I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting the ODBC in SQL Server 2005

    I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

    SQL Server Ask the Experts2,585 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