• MySQL Stored Procedures with Parameters in Crystal Reports 9?

    Hi, I'm using Crystal Reports 9 and the MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way...

    Les za30 pointsBadges:
  • SQL Server multi-user programming with VB 6 and Access

    Hi! I am a new to SQL Server.  Since, I am a beginner, I want to test first before using 2 machines for 1 server and 1 client. Can we use SQL Server Express 2008 for client and server on a same machine where VB 6 is installed having Windows XP operating system (I know I am using old software, but...

    vikasjains20 pointsBadges:
  • How can I scale SQL Azure?

    I'm trying to host my WCF services in Azure for scalability reasons (There will be some read data action / be under High Load). Now, my service will be connected with SQL Azure but I need to know how many concurrent connections can Azure hold per instance? Can I scale it after it reaches its limit?...

    ITKE350,390 pointsBadges:
  • Best way to manage multiple connections in Azure

    My team and I have an application that we're currently migrating to SQL Azure. We've been using "web.config" transformation to manage the changing database connection string development/staging/production environments. What's the best way for us to manage multiple connections in Azure?

    ITKE350,390 pointsBadges:
  • Open IT Forum: What tech blogs and Twitter feeds do you follow?

    Each month, we cast the net asking what [Insert tech topic here] Twitter feeds and blogs you read, but this month is a free for all! We want to know any and all tech blogs or Twitter feeds you trust, admire, and follow religiously. We want links and we'd love to hear why you love them and how long...

    MelanieYarbrough6,345 pointsBadges:
  • Amazon EC2 and SQL Server licensing

    Now, I didn't want to make any assumptions but if I read it correctly, Amazon EC2's Windows with SQL option has the licensing costs bundled with their instance charges. Anyone know if that's actually true? Has anyone used a SQL instance to see if the charges are from Amazon (so you won't have to...

    ITKE350,390 pointsBadges:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri360 pointsBadges:
  • Calling MS Server from iSeries Stored Procedure

    Hi, I have an ODBC linked server connecting MS SQL Server to my iSeries. What products (other than Java), if any, would I need to be able to call a MS SQL Server Stored Procedure from an iSeries Stored Procedure?

    JeffreyStark5 pointsBadges:
  • Would SQL Azure be PCI DSS compliant?

    I'm trying to figure out if I were to separate Windows Server (which was PCI DSS compliant), would it still be compliant if SQL Azure was hosting the back end? I'm only storing permitted values and I'm compliant at the application layer too.

    ITKE350,390 pointsBadges:
  • SOP for cleaning Server rooms

    Hi there, I have been tasked with organizing cleaning of comms, IDF, MDF rooms at our offices. This includes: removing dust from racks, actually all surfaces - cleaning floor , light fixtures etc. Does anyone have a SOP / Method statement of how this should be carried out? Does it require...

    Sinead5 pointsBadges:
  • Add’l CPU per index?

    I'd love to use the LASTUSED column on SYSIBM.SYSINDEXSTATS introduced in DB2 9 to eliminate indexes. I can show my client a number of indexes that have not been used since DB2 9 was installed in July 2009. But I know they will ask 'what is the ROI on deleting these indexes?'. Is there any 'general...

    kjolson5 pointsBadges:
  • Instance specific error when connecting to SQL Server

    What is instance specific error? It is occuring while connecting to SQL Server  ... how can i fix this error?

    FAIZAHAFEEZ5 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • What data should be stored in SQL Azure and Table Storage?

    My team and I are in the planning phase for the typical social networking type of a web application. It includes profiles, messages, chats, groups, albums, etc. But now we're trying to figure out the deciding factors on what data should be stored in SQL Azure and what should be stored in Table...

    ITKE350,390 pointsBadges:
  • Restore a SQL Express 10.0 database

    How can I restore a SQL Express 10.0 database on SQL Express 10.5?

    sam4umore5 pointsBadges:
  • Disk Partitioning w/SQL Server 2000/2005/2008

    I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am...

    JohnMCouch5 pointsBadges:
  • Set up retention policy for deleted items folder on Exchange 2007

    How to set up retention policy for deleted item folder on exchange 2007? I would like to run the policy to empty the folder based on item age. Thank you.

    X4y10 pointsBadges:
  • SQL Server 2008 database backup terminating abnormally

    I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...

    Tablestructure15 pointsBadges:
  • What is a File copy limit in Windows XP?

    Does any one know what is a copy limit in windows XP as when we copy a lot of small files Windows XP stations come up with low resources error ex. we copy 40GB=800000 files windows 2003 server edition is fine no problems.

    Dimchik0 pointsBadges:
  • Import data from Access into SQL Server 2005

    Hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into MS SQL Server 2005. I am receiving info into database access on a daily basis. So I have to do an auto job to import data from access into SQL Server 2005. I think that creating a...

    7715 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