• Member relationship in DB2

    I would like to know the relationship of member in DB2 interms of  MSSQL table. I need the query to fetch member in SQL Server

    sbesuedbknk5 pointsBadges:
  • Call DTS from java

    Please help us whether we can call DTS directly from Java.Solution which we got as below:-1. Create dts2. Create job in which we have to call dts3. Call job from stored procedureIt pretty lengthy process and we are not sure how error handling can be done in this scenario.Request all to help with...

    yyogesh10 pointsBadges:
  • How to configure SQL Server agent

    In my SQL Server, I'm unable to find the SQL Server agent. How do I find it?

    venkat199110 pointsBadges:
  • Dynamic SQL field name

    SELECT ryear rtcur racct rbukrs SUM( tsl06 ) AS tbal SUM( hsl06 )  AS rbal FROM faglflext INTO TABLE lt_bal WHERE ryear =<input>  AND rbukrs IN <input>  GROUP BY ryear rtcur racct rbukrs.     In the above query , how can I dynamically change the field name...

    saselvakumar18105 pointsBadges:
  • Connecting a SQL database to Lotus Domino Designer

    I've been creating a Lotus Notes application that have dynamic combo boxes. Those boxes are going to be retrieved by selecting from a SQL database. Since I'm pretty new to Lotus Domino, could someone help with connecting my SQL database to Lotus Domino Designer? Thanks.

    ITKE342,860 pointsBadges:
  • It seems our SQL database is corrupted

    Hi, Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that were broken but "validate"  always told us that everything is o.k. :-( I had the idea to simple read every record in every table (first "select count(*) from...", second...

    basrhaidi5 pointsBadges:
  • SQL database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • How to repair backup of .mdf file database?

    One of our clients gets the following error when trying to backup a database:quote:________________________________________System.Data.SqlClient.SqlException: SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x121db60d; actual: 0x521db60d). It occurred during...

    jordan26henderson5 pointsBadges:
  • Having trouble connecting Windows Server 2008 R2 to SQL Server 2008 R2

    I've reinstalled Windows Server 2008 R2 on my machine. After that I installed SQL Server 2008 R2 without a problem but I'm having issues when I try to connect with Microsoft SQL Management Studio via my Windows Administration account. Any idea why I can't connect? Thanks!

    ITKE342,860 pointsBadges:
  • Would a Windows Server 2008 Server Core work on a SQL Server instance?

    This may seem old but I've been setting up a SQL Server 2005 on Windows Server 2008 and I'm trying to pare it down to its barebones (while it still being functional). On that, I'm looking at the Server Core but I'm not sure if it will run on SQL Server on that SKU.

    ITKE342,860 pointsBadges:
  • Using Local Variable within Select Statement

    I am pulling sponsorship commitments for two events. I am then trying to look at the sponsorship records for the second event and determine if they are a repeat of the same company sponsoring from the first event. I am trying to accomplish this by seeing if the same company as identified by...

    randybbradley30 pointsBadges:
  • Documenting column in SQL table in QADBIFLD (AS400)

    When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this...

    DanTheDane2,555 pointsBadges:
  • How to trigger email alerts when disk space runs low on Windows Server 2008

    Would there be an easy way to trigger an email alert on Windows Server 2008 when our logical disk partitions run low on space? We have two SQL Servers that are close to running out of space due to our DB log files. Thanks!

    ITKE342,860 pointsBadges:
  • ssma_oracle.to_char_date

    ssma_oracle.to_char_date function was missing in the conversion. Do you have the code for the function?

    ayso2976005 pointsBadges:
  • Comparing results of two MDX query using c#

    Hi, I have to run two MDX query source and target query. And compare the results and show the difference alone. I'm writing the script using C#. Here is the sample code which I'm using I'm able to retreive the cellset but not sure about compare. int col_dim_count_source; int row_dim_count_source;...

    arunpradeepa5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • SQL map error message

    Hello there, on my college website, I got a vulnerable link which is a link of a photo. When I use SQL map with this link, everything works correct. I get to see database and dump even file,but after some time like 5 mins, I get a error like this....

    atulblackshell125 pointsBadges:
  • Error when restoring a .bak file in SQL Server

    I’m having a problem restoring a .bak file in SQL Server. The .bak file is fine and good. But when I restore it, I get an error. It says " TITLE: Restore failed for Server <servername>(Microsoft.SqlServer.Smo) ------------------------------ ADDITIONAL INFORMATION:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database counters in performance in SQL Server

    Hi, This is praveen and I'm working as a performance tester. I am using Windows 7 OS. By default I got the .NET counters in performance, assuming that while installation of LR these will come, but I'm unable to find SQL server counters in performance. If we install SQL Server in my system, will I...

    Manchu5 pointsBadges:
  • Security issues for MySQL in a cloud environment?

    Hi everyone! In general, I've been asked by my manager to find out about running a MySQL DB on a cloud -- has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work on a cloud, and what...

    MillyT5 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