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

    ITKE350,805 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.

    ITKE350,805 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!

    ITKE350,805 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:
  • 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:
  • How to write csv output files one per temp table in one query

    In one query I build four temp tables then I want to write the data from each temp table to its own filename. Is this possible?

    josephcampise335 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:
  • Database replication in SQL Express

    Please suggest me some way about how to replicate data at regular intervals among two or more systems having its own SQL Express database.

    jyotikumari275 pointsBadges:
  • What’s the best way to create a cloud-based SQL database?

    We have a website that's currently being hosted on Amazon S3 and it's working fine. But we have run into a problem with our data (and it's static). So the next step we're looking at is to create a SQL database in the cloud so we can store user data. Could we possibly do this through Amazon AWS or...

    ITKE350,805 pointsBadges:
  • Crystal Reports 8.5

    I have a report that uses SQL 2008 database. It is a money field. I do not want the decimal or the $ sign to show. If it has cents like 1.50 I want it to appear as 150 if it is just 1.00 I want is to be 100. How do I accomplish this?

    llplora5 pointsBadges:
  • How can I open the database of Microsoft SQL Server 2005?

    Actually I have a system and I use the Microsoft SQL Server 2005 for the Database. Can anybody help me. Thanks.

    Gregtf5 pointsBadges:
  • Best value for fillfactor in SQL?

    What is best value for fillfactor in SQL?

    mukeshkumar1210 pointsBadges:
  • How to find a word starting with (‘a’,’b’,’c’,’d’,’e’ or ‘f’) and end with ‘z’ from table.

    How to find a word starting with ('a','b','c','d','e' or 'f') and end with 'z' from table.

    mukeshkumar1210 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