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

    ITKE334,795 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.

    ITKE334,795 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!

    ITKE334,795 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:
  • Long Path Error While Copying/Moving Data

    Hello Frnds, I am very new in this site. I have one problem while I am cpoying/moving the data from the server to the local machine or in the Local machine it self. The problem is that while copying/moving data sometimes is doesn't work due to long path name. Means that if path length is greater...

    Prash7860 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...

    ITKE334,795 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:

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