Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jxc
  • Content: Threads
  • Order by date
  1. jxc

    Scripting Security for a user

    I have a database which contains in excess of 1200 tables. I would like to setup a scripting model which will prevent some users from accessing all but 50 tables. Is there a really quick way to do this?
  2. jxc

    Move System Databases

    I have a requirement to move my SQL server databases from 1 volume to another. I can move user databases without a problem by simply using backup and restore. I am not sure however what is the best way to move the system databases which are created on install. Once moved I need to give up my old...
  3. jxc

    Convert varchar to Datetime

    I have a value in a view which I need to convert to a date and time datatype eq: 199912102359 I have tried the convert function but without success. Thanks in advance
  4. jxc

    Table creation in Master DB

    I accidentally created a table in the Master DB does this create any problems? Can they just be dropped manually?
  5. jxc

    Query problem ?

    I have 2 queries which are almost identical except that the criteria is slightly different. The first query Accountid = "Project1" returns 262,000 rows completes in 1 minute. ( Database has 9,000,000 rows ) The second query Accountid = "Project2" returns 182,000 rows...
  6. jxc

    Index Question

    Can you create an index on fewer entries then the rows in a table (sparse index). I have a table with 30,000,000 rows and would like to have an efficient way of querying the data. Signed newbie to sql indices.
  7. jxc

    Veritas Backup failed - login failed in SQL

    We have recently changed our SQL server from NT security only to mixed(NT and SQL logins). This has caused a problem for our NT logins which were used by the Veritas netbackup client. The SQL activity log simply shows login failed for the NTlogin account used by Veritas. We have tried...
  8. jxc

    Preparing Data for OLAP, Tools to denormalize data

    I am trying to prepare data for OLAP and was wondering if anyone is using a specific tool to denormalize their data. If you are using the tools within MS SQL, perhaps someone could provide an example of a query or DTS package. Thanks /jxc

Part and Inventory Search

Back
Top