if you are running a default instance of sqlserver :

from books online:

net stop mssqlserver

Stops an instance of SQL Server either remotely or locally if you are running the Microsoft...

Seen it .... been there ..... done that .... burned out ..... revived ... bailed out ...

Now I'm having a job that's giving me the occasion to develop my...

Do you mind me posing the question why you would do something like that ???

If it is sqlserver consuming to much memory, you...

maybe this will get you on track ...

INF: How to Shrink the SQL Server Transaction Log

http://www.support.microsoft.com/kb/256650

and yes, you may have to repeat this action a couple of times

same player shoot again .... hit ball when lights are on

Indeed, sometimes we tend to overlook the obvious

Look what I found in my archives ...

Select  'print '' proc to be recompiled : ' ...

In stead of taking them offline, you may want to have a look at AUTO_CLOSE;

Alter database yourdb

          Set AUTO_CLOSE ON / OFF;

This way, SQLserver closes the db when it is not...

I don't have any doco to hyperlink to

We've switched to smtpmail because every once in a while the sp_sendmail got stuck and the...

maybe http://sqldev.net/articles/wait_types.htm can get you on track to solve this issue.

I'd suppose they are just trying to impress by finding out a new slang-word.

I guess what they are trying to find out is...

- you'd probably be better of with using xp_smtpmail (http://www.sqldev.net)

- look for  Configuring Mail Profiles in BOL.

- AFAIK clearing is a all or none operation.

- DON'T mess with systemtables !

   Syscacheobjects isn't even a real table, but contains a systemstate.

- let sqlserver handle it's cache...

- Can you find anything related in Win-eventlog and/or sqlserver-logfiles ?

- Haven't encountered this issue yet, although I also RDC the server to manipulate packages.

- Are you using windows or...

select *

from calllog  T1

left outer join asgnmnt T2

on T2.callid=T1.callid

where T2.assignee='Hanli Burger'

and T1.callstatus='Pending'

Update T1

 set colx = case when T2.coly is null then colx else T2.coly end

from calllog  T1

left outer...

I don't like to propose this, but serverside cursors  can provide that functionality. With the ado-propreties for the resultset/command you can specify a batchset....