• How do I refresh the Stored Procedure used for Crystal Reports datasource

    I have an existing Crystal Report that uses a Stored Procedure as a datasource. The requirements have changed and the Procedure has been updated to have only one parameter instead of two. How do I refresh the Stored Procedure without removing it. I have tried to Verify the Database but just get an...

    Flyght55 pointsBadges:
  • CMPPFM, Space offset error.

    Hello, I'm using the IBM CMPPFM utility for a file comparision process. I monitor for msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to compare the files. This has been working fine until recently, now I'm getting the following error on one file, Space offset X'00FFF026' or...

    Xtreme1145 pointsBadges:
  • SQL DB MIRRORING ACROSS VPN?

    Can SQL 2005 DB mirroring work if the mirror server is to be in another building (building networks connected via VPN router)? We just want employees to be able to remote into the mirror server from home if power is lost at the main building.

    Kareemr695 pointsBadges:
  • Job permissions in SQL Server Agent

    Hi, I'm using SQL Server Agent which is running on SQL Server 2000. My question is, is there a way to give permissions to users to simply view the jobs and not change/execute them? I've read that this is possible in SQL 2005 with SQLAgentReaderRole, but what about 2000? Thanks in advance.

    Dreadnought30320 pointsBadges:
  • Choosing a version of SQL Server on a laptop with Windows Vista

    What version of SQL Server would run back on a laptop with Windows Vista?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Mapping files into SQL Server databases

    I have used the split function utility in UNIX to split large files into multiple files of small length. However, the time it takes to map these files into my SQL Server databases has been reduced performance-wise but not tremendously well. To load 50 milion records, it is taking seven hours of...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Find out what is in dbms_sql cursor

    I am trying to put in a 5500 character query into dynamic sql, and then use the Oracle dbms_sql function to execute the sql. However, there is an error in the sql statement that is being generated, but the error message doesn't help me identify where the error is, as it pertains to the dynamic sql...

    Darryn765 pointsBadges:
  • SQL Server 2000 error message involving ASP

    We are getting a scripting engine exception on the ASP page, but it is actually updating the data to SQL Server 2000. Could the error be due to a SQL Server connection problem?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Shrinking a SQL Server database

    My problem is regarding SQL Server 2000. Whenever I try to access SQL Server Enterprise Manager, I am told that the disk is full, along with the tempdb log. I tried to shrink the database, but for some reason I am not able to do so. Can you help me?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Send a email with attachment?

    How do I send a email with attachment in a sql script using SQL2000

    Mistp00120 pointsBadges:
  • Virtual machine setup – SQL 2005

    I’m setting up a virtual machine -- SQL 2005 install -- and I want to make a separate drive for the logs and one for the data, but as this is a virtual environment using the same mirrored physical disk, is that advisable?

    BladeMarvel35 pointsBadges:
  • Taking a backup of a running site on a SQL Server

    How can you take a backup of a running site on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • The hierarchyid data type in SQL Server 2008

    In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server user instance error

    Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances." idon't know how to solve it

    HishamShiha5 pointsBadges:
  • A Smart Developer

    I have been out of touch from VB Programming for a long long time. In front of me is a task and I am ambitious about doing it in a quick & smart way. I work for a small businessman (a shop keeper) who buys Steel wireropes from wholesalers & sells it as a retailer. Currently he has a manual (cash...

    AmjadM50 pointsBadges:
  • Stored Procedures, One Database, Different Software Releases

    Hi Everyone. Currently at my work we use SQL in our VB.NET code. I have previously always used stored procedures for all of their benefits. My company has said that our customers might use different versions of our software against its one database. For example: While a customer is migrating from...

    Danol215 pointsBadges:
  • SQL Server 2005 query to get the average

    Hi, I'm using MSSql 2005 on Windows 2003 Server. I need some assistance to write a query to get the average of two columns and write the value to a third coulmn. All the transactions is in one table. Basically it is column 1 + column 2 devide by two = column 3 Thank you, George

    GPNel200675 pointsBadges:
  • SQL Server data purging

    I hv a trans tbl and want to keep the records to be purged on Tape/Media and read the data from there whenever required? I want to know, Is that possible to read data from the tape ? if so, then how to do it, neee help

    Taheer725 pointsBadges:
  • Crystal Reports 10

    How To get first record means last entry record of a from crystal report 10

    Asit5 pointsBadges:
  • SSIS and Microsoft Excel

    I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. Sounds simple right? Here's...

    Cathryn35 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