• coloring rows “if” true

    I have a profit & loss spreadsheet that I use to input expected expenses and then log the invoices when they are paid and I always highlight the row when I input the invoice number and invoice amount. Is there a way I can use conditional formatting or a function to automatically color the row if...

    Tstychalski5 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:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 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:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 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 in reunnig sql plus

    when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

    Krshah5 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:
  • xml create form sql database

    i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file

    111111222225 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:

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