Forum Replies Created

Viewing 15 posts - 5,581 through 5,595 (of 9,253 total)

  • RE: LITESPEED xp_slssqlmaint issue

    what is your Litespeed version you are using?

  • RE: SQL Injection Vulnerability Question

    hisakimatama (5/10/2012)


    The application is certainly a Windows-based application, then.

    so it's not exposed to the "outside world" then.

  • RE: cant create logins in SQL

    Sounds like you're going to need single user mode to sort this one 😉

  • RE: SQL Injection Vulnerability Question

    hisakimatama (5/9/2012)


    I'm not sure what the distinction is there, Perry; I'm assuming Windows form would mean something coded in a language such as Java, C#, C++, etc.? Either way,...

  • RE: SQL Injection Vulnerability Question

    hisakimatama (5/9/2012)


    Hrm. Upon looking further into their coding, I've stumbled upon this:

    SET NOCOUNT ON;

    DECLARE @whereClause2 nvarchar(1000)

    SET @whereClause2 = @whereClause

    set @whereClause2 = ISNULL(@whereClause2,'')

    declare...

  • RE: cant create logins in SQL

    soniaj (5/9/2012)


    I added the windows login.

    Which windows login?

    What did you set the as password to during install?

  • RE: SQL Injection Vulnerability Question

    Sql injection is not just about the code, permissions play a part too. Obviously, ensure the database connection has only the privileges it requires.

  • RE: cant create logins in SQL

    What did you set the sa password to during installation, did you add any windows logins during install?

  • RE: restore failed

    surma.sql (5/9/2012)


    but if i shrink log file, then it should work right?

    Yes, but you'll need to shrink the log on the source system, take a fresh backup and then restore...

  • RE: need to shrink Log File

    Ok, as you'll see if you search about you really want to avoid shrinking log files as they generally only grow again at a cost to performance.

    Try to give...

  • RE: XP_Cmdshell 'Access is denied'

    ravisamigo (5/8/2012)


    Hi All,

    xp_cmdshell 'dir \\Server001\e$' - running in Server2

    xp_cmdshell 'dir \\Server002\e$' - running in server1

    OUTPUT : 'Access is denied.'

    But I'm able to access through RUN(WIN+R) command from server1 to server2...

  • RE: Quorum disk failed

    Paul Beetge (5/7/2012)


    Hi Guys,

    Except for the fact that the Quorum is down and SQL can still function, how did you fix the Quorum ?

    Best start a new post, detailing your...

  • RE: question on Cluster 2008

    iamsam.sandeep (5/7/2012)


    1) if there are 2 sql instances in 2 node cluster how many tempdb drives will be adviced as per best practice

    One for each instance 😉

    iamsam.sandeep (5/7/2012)


    2) In...

  • RE: SQL Server 2008 cluster

    For info cluster.log no longer exists on windows 2008. Open the fail over cluster manager and view events there. You can export cluster events to a log using the cluster.exe...

  • RE: DB Mirroring with Clustering

    Simha24 (5/7/2012)


    I am Trying to create mirroring on different instance in Node N2 But it useses same Virtual Name

    Forget the node names, for the most part in a cluster they...

Viewing 15 posts - 5,581 through 5,595 (of 9,253 total)