Forum Replies Created

Viewing 15 posts - 16 through 30 (of 101 total)

  • RE: Connect Issue

    Thanks to MyDoggieJessie. It really worked for me.

    March 24, 2014 at 5:53 am

    #1699489

  • RE: Problem to get data from Excel 2007

    I created a user "shohel" with Administrative rights in windows and I ran SQL Server Services by this user. I use Windows 7 Ultimate. The problem is sometimes I get...

    February 25, 2014 at 1:37 am

    #1691777

  • RE: Problem to get data from Excel 2007

    @happycat59,

    Thanks for your thought.

    First thought: The file is on drive D: on that machine.

    Second thought: Yes, I have installed the driver named "AccessDatabaseEngine".

    At last I could successfully execute...

    February 24, 2014 at 11:46 pm

    #1691764

  • RE: Import Data From Excel File

    Thanks for your useful link.

    February 23, 2014 at 4:18 am

    #1691357

  • RE: Write a conditional query

    Thanks all. Specially to GilaMonster and Lowell for your valuable suggestions.

    It helped me.

    February 3, 2014 at 10:40 pm

    #1685731

  • RE: Database is Synchronizing & Log Backup

    GilaMonster (1/30/2014)

    No difference

    Thanks. That's Great!

    January 31, 2014 at 8:22 pm

    #1685268

  • RE: Database is Synchronizing & Log Backup

    @Gila Monster,

    Thanks for your help. I have already configured database mirroring. So, its not a new setup.

    Actually I took a log backup of principal database when it was on the...

    January 30, 2014 at 4:24 am

    #1684587

  • RE: Sending Email Using Database

    thank you, pietlinden.

    I got ur link the most useful.

    October 4, 2013 at 4:23 am

    #1655822

  • RE: Getting Back Previous Database

    SQLRNNR (7/30/2013)

    If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.

    NO WAY TO GET BACK?

    July 30, 2013 at 10:23 pm

    #1637203

  • RE: Find the host name

    GilaMonster (7/17/2013)

    Read up on SQLAudit, Change data capture, change tracking, see if any of them do what you want.

    Thanks I have no idea of SQLAudit, Change data capture, change tracking....

    July 18, 2013 at 2:29 am

    #1633558

  • RE: Find the host name

    Thank GilaMonster and Hanshi for your comments.

    So, in future what should I do to trace DML operations performed by the host name?

    July 17, 2013 at 2:39 am

    #1633142

  • RE: Know the Action Doer in Database

    SQLSACT (7/9/2013)

    If you are trying to track changes on your database, you could implement SQL Auditing. You could also look at introducing triggers to track any changes.

    Thanks for your help....

    July 9, 2013 at 1:39 am

    #1630672

  • RE: T-LOG ISSUE

    @kevaburg, I think so that my log file has got its optimal size.

    Actually I check log space regularly and take a log backup when necessary because there are...

    May 25, 2013 at 11:14 pm

    #1618563

  • RE: T-LOG ISSUE

    GilaMonster (5/21/2013)

    shohelr2003 (5/21/2013)

    2. Nope, log is not always 87% empty. I monitor it regularly, it becomes like for example 58%, 35%, 12%, 1% free. Then I take log backup and...

    May 21, 2013 at 5:42 am

    #1616943

  • RE: T-LOG ISSUE

    Kingston Dhasian (5/21/2013)

    Do you have scheduled log backups or do you monitor and take the log backups manually?

    I have not scheduled it but I do it manually.

    May 21, 2013 at 5:38 am

    #1616941

Viewing 15 posts - 16 through 30 (of 101 total)