Alter PROCEDURE [dbo].[Get_TableValues]

              @Value as varchar (100)

AS

begin

set nocount on

if @Value  = 'Model_No'

     Select Distinct Model_No FROM [IT].[dbo].[test]

if @Value = 'Proj_Engineer'

     Select Distinct Proj_Engineer FROM [IT].[dbo].[test]

end

- you can you profiler to generate a trace-script to be executed trace-to-file.

Then schedule a sqljob to activate the trace.

You might even put the trace-part in a stored proc, if...

check out datediff(mm, lowerdate, higherdate)

yes.

prior to sql2005 sqlserver would search for ...

databaseName.YOURLOGINUSER.orders    

then for databaseName.DBO.orders    

with sql2005 it will start searching for ...

databaseName.YOURDEFAULTSCHEMA.orders    

then for databaseName.DBO.orders    

is this a backup file ?

If yes, maybe there is a backup-device pointing to it ...

exec sp_helpdevice

you can rerout it using

begin tran

exec sp_dropdevice @logicalname = 'yourdevicename'

exec sp_addumpdevice  @devtype =...

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...