Forum Replies Created

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

  • RE: SQL Injection

    Lynn Pettis (2/4/2009)


    Paresh Prajapati (2/4/2009)


    I got one new external IP from sql server errorlog..error like ''Login failed for user..client [external IP address].

    I know that this is not our company internal...

  • RE: SQL Injection

    I got one new external IP from sql server errorlog..error like ''Login failed for user..client [external IP address].

    I know that this is not our company internal IP..So, someone hacked or...

  • RE: Large transaction log files

    j.grimanis (1/25/2009)


    Does Index Rebuilt prevent users from login?

    The database had heavy loaded tables that time.

    Thank you

    John

    It will prevent table..but prevent to use indexes..

  • RE: DB Mail

    binu.ma (1/25/2009)


    Hi

    I am having problem with dbmail.When I am trying to send mail in the event viewer i am getting the error

    Web page returned error: ERRORS

    exec soe.dbo.BlueappsRead error: -2147217911, 'Microsoft...

  • RE: DBCC Shrinkfile to a size not working - why ?

    ifila (1/21/2009)


    I have tried to shrink my sql 2008 DB using both a sql query and via sql server mgmt studio and it says it has 98% free space but...

  • RE: DB Corrupt

    Lee From Bangalore (1/22/2009)


    How to find MDF or LDF is Corrupted?

    Plz give ans

    IT MAY BE ANY REASOM LIKE LOG FILE IS OUT OF SPACE..

    U CAN RUN DBCC CHECKDB TO RESULTOUT..

  • RE: 16 digit unique number

    RBarryYoung (1/21/2009)


    Well @@DBTS can technically do what the OP asked. Of course that is only within the scope of a single database (no mention of scope in the original...

  • RE: 16 digit unique number

    amartha_dutta (1/21/2009)


    Dear Friend,

    How about looking into manipulating the current system date & Time.

    Use GetDate(), Remove the spaces and append with some other characters / digits of your choice (Based upon...

  • RE: 16 digit unique number

    krayknot (1/20/2009)


    Paresh Prajapati (1/20/2009)


    Can have script to generate 16 digit unique number which contain both character/Number..

    which should be not duplicate in future also.

    declare @random varchar(50)

    set @random...

  • RE: Deleted DBs

    MichaelJasson (1/17/2009)


    Yesterday I created five DBs but someone dropped them in the night only. I am not sure who has done that. I shall be looking at the privileges soon....

  • RE: Truncate log file

    GilaMonster (1/17/2009)


    MichaelJasson (1/17/2009)


    I wanted to understand where this backup is taken. I couldn't find the backup of the transaction log.

    It's not. That's the whole point. TRUNCATE ONLY means don't write...

  • RE: Backup Scripts

    Mike Levan (1/17/2009)


    I looking for backup scripts which serves my scenario.

    I have very huge databases residing on 4 servers. All databases has multiple files like partion files according to the...

  • RE: Restore Database Without Log

    Paul Randal (1/17/2009)


    Paresh Prajapati (1/16/2009)


    Tim Riley (1/8/2009)


    I know there is, but I can't remember how...How do you go about restoring a database that has a corrupt/bad transaction log?

    Please take a...

  • RE: SQL 2005

    ravikumar.niit8729 (1/15/2009)


    hi,

    Please let me know that how to create table with "Image field" and inserting pictures into that table?

    Thanks,

    if u want how to generate image from image field by sql...

  • RE: How do I recover data from SQL Server's log files?

    Ravikumar.msc (1/10/2009)


    How do I recover data from SQL Server's log files?

    UPDATE foo1 SET relID = 5

    After I hit F5, I realize: oh dear, I forgot to add a...

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