• Using iSeries as linked server in SQL Server 2012 Express

    I downloaded SQL Server 2012 Express in order to attempt to create a database on a PC which has links to data living on our iSeries. I can't use the OLE DB2 extension from Microsoft since it doesn't work on SQL Server Express. So, I figured out (with Google's help) that I could run this script to...

    Koohiisan5,020 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • Database file in Novell GroupWise

    what is a data base file in novell groupwise.Is it associated with each novell file or there is only 1 which contains info for all other file

    PCVITA15 pointsBadges:
  • Matching key question – resubmitted

    Hi, resubmitting because the first upload did not seem to work... Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3...) Col2 has letters...

    Slowlearner25 pointsBadges:
  • Temporary Internet Files ( long file names – can’t delete )

    I have come across a few files on several computers that have files with long names in the temporary internet files folder. The files can not be renamed or deleted. Has anyone come across this problem before and if you have, Please let me know what worked for you. I have tried deleting the files...

    Sheldonrw0 pointsBadges:
  • External Table / SQL Loader

    Hi, We are using this new sqlloader for a month nowmand it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge...

    External10 pointsBadges:
  • SQL Server Database Maintenance Performance and Hyperthreading

    I have two IBM machines with the same exact hardware 32 cores, 256GB RAM for each machine. One machine has Hyperthreading enabled and the other does not. When I run maintenance jobs (dbcc checkdb, and rebuild index) for the database that is 1TB the maintenance job takes 8 hours on the machine that...

    Rick Martinez585 pointsBadges:
  • SQL Server 2008 restore error

    error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server....

    Kazem10 pointsBadges:
  • Open IT Forum: What tech CEO would you vote for?

    Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts -- or your vote -- and...

    ITKE345,295 pointsBadges:
  • Crystal Reports using SQL to create inner join

    I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don't put any fields on the report from the joined table.  ie  -  if I just use fields from "sal-rep" the report works.  As soon as...

    Sparis5 pointsBadges:
  • detach the .mdf files from sql server

    hello, i am trying to detach the database from sql server. well the seniorio is i am try to do automate everymonth to detach all the previous month .mdf files. so is it possible to automate it to detach the previous months database by getting the system current date.

    Helpmeout55 pointsBadges:
  • SQL Server equivalent of Oracle’s “when no data found” exception

    In a stored procedure, I'm storing the result of a select statement in @variable. Is there a way to capture a SQL Code 100, like Oracle's SQLERRM(100)/ORA-01403 if no records are returned? I'm currently setting @variable = '*' before the select and and IF @variable = '*' afterwards, but there must...

    CO Bill120 pointsBadges:
  • Invalid String or buffer length ERROR

    I am trying to connect to SQL server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->sql is the data source name.. I catch this Exception.. Many thanks in advance

    1023965 pointsBadges:
  • SQL Server 2008 Restore Fails – There is insufficient system memory in resource pool ‘internal’ to run this query

    I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error. 100 percent processed. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. Msg 701, Level 17, State 123, Line 1 There is...

    MTLONDON20 pointsBadges:
  • Using Report Server in SharePoint 2010

    In SharePoint Integrated Mode of SSRS 2008, how do you get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods? This question is from...

    ITKE345,295 pointsBadges:
  • error in creating new database using sql server

    I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?

    Ladylynn15 pointsBadges:
  • SQL Select: Getting the previous records from a known record

    I issued a select statement like this: Select phone# from pltlcd where phone# >= 985143525 fetch first 20 records only PLTLCD is a file sorted by phone#. From the first record retrieved by the aboe select statement, how do I get the 20 records in the file that exist before the returned set of...

    bogeybetsy560 pointsBadges:
  • Replication and run backups

    I am running SQL 2008 with replication between 2 locations. Will the running of backups impact the replication process. Can I run both on the same database?

    mf125 pointsBadges:
  • Connecting SQL server 2005 with IAN connection

    how we can connect sql server2005 with lan area? what are all the settings and options want to change?

    Shajidjame5 pointsBadges:
  • get the value from XML in a sql table

    i created a table which contains many columns. out of that one column is having xml codings which are saved as xml info.  We are having number of parameters in one row data of that xml info. Like this we are having multiple rows. I want to select the value from the xml column of that table using...

    Rithunsi5 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