use db;
select * from sys.table|views|procedures|types where name like '%your mum%'###basics
case of switches is important!
sqlcmd -S<server name> -d<database> -Q"select * from urmum"
###running a script
example.sql:
-- warning you should always test for externally defined parameters either logic short circuiting or try to
-- string reverse the variable.
-- predefined var
setvar Foo 31337
select * from bar where id=$(foo) and flag='$(PassedParameter)'sqlcmd -S<server name> -d<foo> -iexample.sql -vPassedParameter=Y
####formatting output (fixed width)
YMMV depending on number of columns returned
sqlcmd ...usual shit... -Y<nn> ...usual shit...
--source: http://technet.microsoft.com/en-us/library/ms176097(v=sql.105).aspx
select * from fn_my_permissions('dbo.vw_Currency', 'OBJECT') alternative solutions: http://consultingblogs.emc.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions.aspx
##view object source--ctrl-t (text mode)
sp_helptext 'dbo.vwAwesome'select * from foo;