Right click on your server in EM, select EDIT SQL Registration property,

in Options session, clear Show system databases and system objects check box.

Try this, it uses function instead of stored procedure. One can modify as needed.

use pubs

go

select * into test from authors

go

create function fn_Count_fields(@au_id as varchar(11))

returns int

as

begin

declare @res int

select @res = sum(

 case...

I wrote a script to delete leading space.

Save it to delleadingspace.wsf

Find syntax by delleadingspace.wsf /?

<job id="delleadingspace">

 <runtime>

  <unnamed

    name="filename"

    helpstring="The file to process"

    many="false"

    required=2

  />

  <usage>

   Delete line leading space from a...

You can only do this if TestSharesTable is a scalar function.

Only sysadmin and serveradmin can execute sp_configure for updating. The check is carried out at runtime.

select a.widgetname, widgettype

 into #aa

 from table2 a

 inner join table3 b on a.widgetid = b.widgetid

 inner join table1 c on b.itemid = c.itemid and c.itemname='AAA'

select * from table2 a

 where exists(select * from #aa...

If it is a single log file database, one option is sp_detach_db, delete the log file, than sp_attach_single_file_db, it will creates a new log file.

Check BOL for detail.

use queryout, and in the query select col1+col2 from table.

Will XMLDATA in for xml help?

select serverproperty('collation')  for server

or

select databasepropertyex('dbname', 'collation') for a db

use textptr and writetext functions to deal with image field.

declare @sql varchar(400)

set @sql='backup database ? to disk=''c:\temp\?.bak'' with init'

exec sp_msforeachdb @sql

You can use textcopy utility from SQL server.

Find out syntax Textcopy /?

One can find the utility in mssql\binn folder.

http://support.microsoft.com/default.aspx?scid=kb;en-us;833305

You may have to use WITH MOVE option.