Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: A way to prevent users from using QA or EM?

    Why can't you just use windows security to block it?

    Go to the mmc for enterprise manager and the exe for query analyser and deny access to the users who don't...

    September 3, 2003 at 3:39 am

    #472331

  • RE: SQL Help Needed

    JulieW,

    Heres an idea, it's a bit ugly but should work - though you need 2 queries. Hopefully someone else has a suggestion because I'd like to know a nice way...

    September 1, 2003 at 4:41 am

    #472092

  • RE: Export to Excel without DTS. Possible?

    hanslindgren,

    If you write a file with .xls extension that looks something like this:

    <HTML>

    <HEAD>

    <META HTTP-EQUIV=Content-Type CONTENT=application/vnd.ms-excel>

    </HEAD>

    <BODY>

    <TABLE>

    <TR>

    <TD>Some cell</TD>

    <TD>Another cell</TD>

    </TR>

    </TABLE>

    </BODY>

    </HTML>

    When you open it Excel should display it as a a standard Excel document...

    August 28, 2003 at 3:00 am

    #471761

  • RE: Export to Excel without DTS. Possible?

    Frank, thanks - that is just the sort of thing I was looking for.

    planet115 - I think you're right. I know Excel docs can also be an html doc with...

    August 27, 2003 at 7:36 am

    #471597

  • RE: Controlling SQL Server jobs from cmd

    Thanks everyone, all is now well.

    March 21, 2002 at 5:45 am

    #425797

  • RE: Recovering a dB without a current backup

    Thanks for that. The logs were truncated.

    But I got LogExplorer anyway, it will be very useful.

    Thanks for your help.

    September 28, 2001 at 2:36 am

    #418565

Viewing 6 posts - 1 through 6 (of 6 total)