In System Catalog Views sys.server_principals and sys.sql_logins.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Where are Usernames and Passwords stored in SQL Server ?
Sunday, March 20, 2011
In System Catalog Views sys.server_principals and sys.sql_logins.
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you change the server level settings in SQL Server ?
What are the types of Cursors in SQL Server ?
1. Static
2. Keyset-driven
3. Dynamic
4. Fast-Forward only
www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
How will you get the last error no in SQL Server ?
How will you get GUID in SQL Server ?
Daily Tips- Tip #85 - SQL Performance Tuning
sp_depends is the stored procedure is used to know which table use a rule or default.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #84 - SQL Performance Tuning
sp_unbindrule is the stored procedure which is used to unbind rule from table.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #83 - SQL Performance Tuning
sp_bindrule is the stored procedure which is used to bind rule to table.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #82 - SQL Performance Tuning
sp_helptext is the stored procedure which gives details about rules and defaults.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #81 - SQL Performance Tuning
sp_helpdb is the stored procedure which gives details about database.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #80 - SQL Performance Tuning
sp_help is the stored procedure which gives table details.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Daily Tips- Tip #79 - SQL Performance Tuning
sp_helpconstraint is the stored procedure to view constraints.
www.codecollege.NET|http://www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning
Subscribe to:
Posts (Atom)
LinkWithin
