• 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:
  • 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:
  • 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...

    ITKE351,865 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:
  • 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...

    ITKE351,865 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:
  • SQL Server Failover Clustering or DB Mirroring

    Hi,   I need to clarify some concerns with regard to the options available on SQL Cluster deployment, but before that let me give you a background on the infra layout so we are on the same page:   We have two physical servers + FC SAN (iscsi not supported in the current model) to setup Hyper-V...

    Azeee20 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:
  • SQL How to split out the Time from a DateTime col then use that in a WHERE Clause

    Hi, I have an SQL Server database that has a table containing 3 fields that I need to query. 1 field holds the date, and the other 2 hold the start and end times. What I was hoping to do was to split out the time only from the Start and End time fields and then use these times in the WHERE clause...

    Darraca290 pointsBadges:
  • session error

    Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan't get rid of error. User's...

    tcstl95 pointsBadges:
  • TSQ

    i have an output MAP like.. Roll no :01 Name   :XXXXXXXX Post     :qwe               (DEV,TSE)-This are option for post.   message: Invalid post --------------------------------------------- showing the error message i have moved low-value to the map all the entered data...

    Nizarudeen5 pointsBadges:
  • SQL Server Data file Shrinking

    We have the database in SQL server 2008 and size is nearly 160 GB.We have configured Transactional Replication on this database(Only few tables).There are 50% of free space available on Datafile. To reduce the disk usage We try to shrink the datafile, but unfortunately the file does't shrunken.The...

    asenthil175 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