using cmdshell it will work if you have the authority.

exec  xp_cmdshell 'date ....'

did the hyperlinks bring any light in the darkness ?

Search the KB, there were more articles where you can find "bpool" ..

First things we do is add the windows SQLserver-administrators-group as login and add it to the sysadmins serverrole.

Then we always remove builtin\administrators from the sqlserver-logins !

Our SQLservers all run using a windows...

Keep in mind you can only start jobs you own !

To avoid overauthorising users so they can start jobs, I use an alert which starts the job, so they only raise...

Windows version ?

SQLServer version ?

AWE enabled ?

(check

 -  http://support.microsoft.com/default.aspx?scid=kb;en-us;319477&Product=sql2k 

- http://support.microsoft.com/default.aspx?scid=kb;en-us;323212&Product=sql2k

Jonathan

SQL7 -> no cascading deletes through DRI. That must be done using triggers.

Dan,

The DRI-checking will be done by sqlserver, so provide FK-indexes to support it.

If those indexes hurt performance to...

My guess,

you have a table with nullable columns that you use with a unique index.

A primary key constraint cannot be defined on nullable columns.

With a unique index, you can...

should be single quotes ..

SELECT @TestSql = 'INSERT INTO @TestTable SELECT au_id,au_fname From [pubs].[dbo].[authors] '

EXECUTE (@TestSql)

Is this what you're looking for ?

select J.Name as JobName, RP.program_name

 from msdb..sysjobs J with (nolock)

  inner join  master..sysprocesses RP with (nolock)

      on RP.program_name like 'SQLAgent - TSQL JobStep (Job '...

I hope your day today will be mutch better

Regarding the hyperlink : Believe me, once you seen Sheryl explain the whole stuff, you'll...

No, this only means that a litle testing is advisable for anyone who wants to build some knowlage of an rdbms. It's not because any solution works "optimal" for me,...

I thought the smilies would give enough indication that that reply was only ment to be a litle dry humor. After all there was no sql-technical info involved

As always, you'll have to compare execution plans and runtimes to build your choice on. Hey, this may even by the occasion for a 'aha-erlebnis'

Hey, I thought the were bits and pieces of bricks and cement with your last reply

As far as I'm concerned you may as well...

Perform it on both, maybe that gets it all into the daylight, but at least perform it where you are having the problem (i.e. the select).

- QA\Query\display estimated execution plan...