Re: denying permissions on the view's underlying tables

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 06/12/03

  • Next message: Ed the CISSP: "I see whats wrong with forced protocol encryption now! Heres the easiest solution." 
    Date: Wed, 11 Jun 2003 21:04:17 -0500

    You can check the SQL 2000 service pack level with:

        SELECT SERVERPROPERTY('ProductLevel')

    I answered your first question in your other thread. 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"Pete Ruby" <pete.ruby@carris.net> wrote in message
news:ejNaJrCMDHA.304@tk2msftngp13.phx.gbl...
> Brian,
>
> I have an issue like yours.  First, how do I find the SP of SQL 2000
> (running NT4, SP6a).  Second, where do I change that setting that
Russell
> mentions?  i have databases on the same server.
>
> For more info, see the thread  "one SQL DB getting info form another -
user
> setup?"
>
> Pete Ruby
>
> "Bryan W. Brown" <bmail@imagin.net> wrote in message
> news:052401c3205b$893c0270$a001280a@phx.gbl...
> > That worked great!!  We ran some tests and will be
> > implementing it very soon.
> >
> > Thanks.
> >
> >
  • Next message: Ed the CISSP: "I see whats wrong with forced protocol encryption now! Heres the easiest solution."

    Relevant Pages

    • Re: Help with Names
      ... First question is the toughie. ... How regular is your data. ... SQL Server MVP ... > The source is an excel spreadsheet that I've imported in to SQL 2000. ...
      (microsoft.public.sqlserver.programming)
    • RE: Transferring tables between SQL2005 databases causes error
      ... you import data from one SQL 2005 database to another; ... For your first question, ... Had the destination database tables created with constraints before ... its size were equal to the destination table column type and the size. ...
      (microsoft.public.sqlserver.dts)
    • Re: Display Database Query in Visio
      ... I guess the first question is, what are your sql skills since it is ... I have a network diagram with a number of system (server) components ... What I want is a way of performing a SQL query based on a value of one ...
      (microsoft.public.visio.developer)
    • Re: SQL Server Clustering - OS(64-Bit) SQL (32-Bit)
      ... This applies on a cluster as well as a stand-alone ... system, so the answer to your first question is yes, it can be set up that ... You cannot do an in-place upgrade because of the 32 to 64 bit ... but you can install a second SQL instance using SQL 2005 on the ...
      (microsoft.public.sqlserver.clustering)
    • Re: Trying to Move Group - SQL Instance Wont Start
      ... You can do a maintenance install and add the new nodes. ... You will have to undo the manual allowed nodes settings and then follow the instructions in "maintaining a failover cluster" for recovery from failure scenario 1. ... SQL 2000 on Windows Server 2003 allows up to four nodes in a cluster so you should be good to go. ... > Microsoft SQL Server MVP ...
      (microsoft.public.sqlserver.clustering)