<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tags
Programming
,
Stored Procedures
,
Security
Refine your search with one of the following additional tags (with number of items):
T-SQL
(2)
Miscellaneous
(1)
SQL Server 7, 2000
(1)
Administering
(1)
Performance Tuning
(1)
SQL-DMO
(1)
Basic Querying
(1)
SQL Puzzles
(1)
Strategies
(1)
Items 1 to 4 of 4
Logins, Users, and Roles - Getting Started
Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.
Read more...
By
Andy Warren
2005/09/30 (first posted: 2003/02/19)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
32,573 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
42,558 reads
Dynamic SQL or Stored Procedure
We've had a lot of coverage of dynamic sql (including another great one from Robert Marda later this week) but this one is a little different. Done in a question/answer format, Andy tries to explain to junior developers why dynamic sql is to be avoided, how to do so, what to do when you can't.
Read more...
By
Andy Warren
2005/08/26 (first posted: 2003/04/23)
|
Source:
SQLServerCentral.com
|
Category:
Performance Tuning
Rating:
|
Discuss
|
Briefcase
|
42,558 reads
Logins, Users, and Roles - Getting Started
Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.
Read more...
By
Andy Warren
2005/09/30 (first posted: 2003/02/19)
|
Source:
SQLServerCentral.com
|
Category:
Administering
Rating:
|
Discuss
|
Briefcase
|
32,573 reads
Items 1 to 4 of 4
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
