Hi

If you want database users then sp_helpusers will give them. If you want

logins then sp_helplogins will list them.

The advantage for cascading is that you don't have to do any checking and programming to avoid data inconstency. Disadvantage is that you don't have any control about the updates/deletes...

Hi

Just go thru this:

http://www.sqlservercentral.com/Forums/FindPost635137.aspx

Hi

This link may be useful...

http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/

Hi

Thats a great link..Thanks...

Yes..

The user executing that should have the grant privileges...

Hi

This link may be useful

http://nickstips.wordpress.com/2010/10/18/sql-making-a-stored-procedure-available-to-all-databases/

Hi

also go thru this link, if required:

http://nickstips.wordpress.com/2010/10/07/sql-get-login-database-and-server-role-membership/

Hi

Pls use this query

SELECT * FROM dba_users ORDER BY CREATED DESC

or

SELECT * FROM dba_users WHERE username LIKE 'xxx%' ORDER BY CREATED DESC;

Hi

Prima facie, it seems that ur database object, ie. table does not exist in the DB.

Hi

Just try '2010/12/15' instead of the one used.

Hi

Pls refer this link

http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx

Hi

This link may be useful to you

http://zielynsqlblog.com/2010/02/10/convert-an-xml-variable-datatype-to-relational-table-sql-server/

Hi

I'm looking for both..

Need some examples to know, how its really works.

Hi

Only members of the sysadmin fixed server role can execute sp_changedbowner.

To display a list of the valid login values, execute the sp_helplogins stored procedure.