Forum Replies Created

Viewing 15 posts - 1 through 15 (of 68 total)

  • RE: Websphere to MSSQL via JDBC Good idea?

    We have couple of applications that run on this kind of architecture. One of them is a warehouse management application that is based on Hibernate and it has been able...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Database in Recovery mode from last 7 days.

    GilaMonster (2/8/2013)


    The only thing you can do for a recovering database is wait. If the schedulers are still hung may require another restart, bear in mind that'll undo any recovery...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: SQL Cluster - Uninstall/Break

    Hopefully, this answers your question on removing the node from the cluster.

    http://msdn.microsoft.com/en-us/library/ms191545(v=sql.90).aspx

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Database in Recovery mode from last 7 days.

    [font="Verdana"]Parminder,

    Could you provide us some more information as to how the database went into recovering mode?

    Are there any messages in the errorlog that say that the DB was shutdown?...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Problem with "If Exists (Select ...) Or Exists (Select ...)"

    Just wanted to point out that OR combines two conditions. As far as I know; it means that 'Expression A' and 'Expression B' are evaluated and then the OR operator...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Stairway to SQL PowerShell Level 1: SQL PowerShell Basics

    Good post 🙂

    I would've loved it if you could have covered the profiles also as part of the introduction as it becomes an integral part of the whole experience.

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Working with Perfmon CSV logs in Powershell

    alexf01 (3/6/2012)


    Very interesting!

    Just one question, what does this mean:

    When working with large CSV files, instead of piping the output of Import-Csv cmdlet is a little faster and does not consume...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Me, myself and Powershell

    Automating daily tasks is not only easy with Posh but, fun as well 🙂

    Chad Miller's MSCS code on poshcode site is a wonderful starting point if you want to...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Logging Perfmon counter data in database

    Or simply use logparser from microsoft. I think version 2.2 is the latest that was released. Anyways, once you have logparser you can query your csv file in SQL like...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Setting up a SQL cluster under MS VS2005 R2 Part1

    [font="Verdana"]Excellent article Perry 🙂 and here is another set of articles that might be an interesting read for the users on the same topic. Hope you guys find these articles...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Some User Databases gone suspect during SQL Server 2000 Service account change

    [font="Verdana"]Yes, it looks like the new service account does not have access to the folders specified. Try giving the new service account full access to the folders and see what...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: I/O error 170(The requested resource is in use.)

    Laerte POltronieri Junior (12/24/2008)


    Hi all

    I have some problems with one environment..

    It was a virtual cluster active/passive with 2 virtual nodes and virtual disk in procution and onde node is...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Log file is in Use

    [font="Verdana"]Shirnking databases is not normally advised, if you have the resources. But since, this is a development database...you might want to try this code. Don't use it on production 🙂

    USE...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Grant Alter View,Proc Permission without being a DDLAdmin

    roja.hafezi (12/22/2008)


    You can add your users to db_ddladmin role !:D

    He said, without granting the db_ddladmin role.

    Anyways, I had the same problem any suggestions on how to achieve this in...

    -Hope is a heuristic search :smooooth: ~Hemanth
  • RE: Delete OS Files using sql server 2005

    [font="Verdana"]Do read, the link that ps has posted. But, this code should help you out:

    SET NOCOUNT ON

    DECLARE @iFileExists INT

    create table #table (File_exists int, File_directory int,parent_dir int)

    --If the path has spaces...

    -Hope is a heuristic search :smooooth: ~Hemanth

Viewing 15 posts - 1 through 15 (of 68 total)