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 strongm 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: *

  1. coolmoe

    Encryt password field in sql

    How do I encrypt a password in a sql database?
  2. coolmoe

    Blocking Table Access in SQL Server

    Because I not sure of the capability of denydatareader role and they do need to access a couple of tables.
  3. coolmoe

    Blocking Table Access in SQL Server

    Currently, I am going through our 500 tables or so one by one in the permissions area for each user and 'x' out the 'select' column for each table. This is time consuming. How do I do it with script or code?
  4. coolmoe

    Join to a table in another database on a different server

    Not sure how to do either one
  5. coolmoe

    Join to a table in another database on a different server

    am looking at reference a sql server database from a separate sql server database. server 'a' has table 'tbl_cars' server 'b' has table 'tbl_colors' i wish in a stored procedure for example to link from server 'a' to tbl_colors in server 'b'. also, there is a login and password to get to the...
  6. coolmoe

    i am looking at reference a sql ser

    i am looking at reference a sql server database from a separate sql server database. server 'a' has table 'tbl_cars' server 'b' has table 'tbl_colors' i wish in a stored procedure for example to link from server 'a' to tbl_colors in server 'b'. also, there is a login and password to get to the...
  7. coolmoe

    accessing a table on another server

    Actually, i am looking at access another sql server database from another sql server database. server 'a' has table 'tbl_cars' server 'b' has table 'tbl_colors' i wish in a stored procedure for example to link from server 'a' to tbl_colors in server 'b'. also, there is a login and password to...
  8. coolmoe

    accessing a table on another server

    How does one through a sql statement access table 'coolone' located on server 'a' from server 'b'?

Part and Inventory Search

Back
Top