Forum Replies Created

Viewing 15 posts - 45,511 through 45,525 (of 49,552 total)

  • RE: Calling a Stored Procedure from a View

    CrazyMan (7/22/2008)

    how can we do that???

    Do what?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 12:11 pm

    #846604

  • RE: Calling a Stored Procedure from a View

    Can java cache a call to a udf? If so, then you can convert one of those queries into a udf with the two parameters and do a select *...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 12:08 pm

    #846598

  • RE: Calling a Stored Procedure from a View

    Or, if you prefer (assuming no parameters)

    CREATE VIEW IsRowThere AS

    SELECT CASE WHEN Row_Count >0 THEN 'True' ELSE 'False' END As ItsThere

    FROM

    (SELECT COUNT(*) AS row_Count FROM Sometable Where SomeConditions) x

    GO

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 12:03 pm

    #846593

  • RE: Calling a Stored Procedure from a View

    Can't java call stored procedures?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 11:59 am

    #846588

  • RE: Problem with Auto Shrink

    Try killing the data import. Is it blocked by the shrink? If so, the shrink will finish and then the import can continue.

    You are going to switch the autoshrink off?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 11:54 am

    #846579

  • RE: who is connected to my db SQL 2000

    exec sp_who2

    or

    select * from sysprocesses

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 11:32 am

    #846562

  • RE: Calling a Stored Procedure from a View

    CrazyMan (7/22/2008)

    Hi Gila

    I found a work around, but iam facing error, the work around is

    select * from OpenRowset...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 11:31 am

    #846561

  • RE: Regarding extended stored procedure.

    saurabh.punn (7/22/2008)

    Hi

    This is wht i m got:

    Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1

    The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.

    Please ask your...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 11:11 am

    #846546

  • RE: Calling a Stored Procedure from a View

    Not possible. A view is a single select statement.

    Could you explain a bit more why you're trying to do this?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 10:59 am

    #846537

  • RE: SQL 2008 login issues

    What rights does Domain name\DC login have on the machine running SQl server? Is it local admin?

    Have a look in the error log (it's just a text file if you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 10:58 am

    #846536

  • RE: Regarding extended stored procedure.

    No it won't. dbo is not a server-level principal. It's a database-level principal.

    Did you ask him about impersonating a sysadmin?

    whenever i m trying 2 execute the xp_fileexist proc by mentioning...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 10:55 am

    #846534

  • RE: 3 table join even if not exist

    Neither. Do a 2 column join

    select t.ItemNo, t.BatchNo, a.qty, b.qty, c.qty from

    (select ItemNo, BatchNo from TableA union select ItemNo, BatchNo from TableB union select...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 10:52 am

    #846533

  • RE: SQL Server 2008

    Anything in particular you're looking for on 2008?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 10:49 am

    #846530

  • RE: nested queries

    dcorbitt (7/22/2008)

    Stick it in a sproc so you don't have to look at it. No promises on the speed, but might be okay.

    Another option would be a cursor with a...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 9:30 am

    #846481

  • RE: Regarding extended stored procedure.

    Please ask your dba if it is acceptable for the stored proc to impersonate a sysadmin login.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    July 22, 2008 at 9:13 am

    #846466

Viewing 15 posts - 45,511 through 45,525 (of 49,552 total)