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...

  • 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...

  • 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...

  • 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...

  • RE: Controlling SQL Server jobs from cmd

    Thanks everyone, all is now well.

  • 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.

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