Try using the exec command.

declare @pid as int

set @pid = 50

exec ('kill ' + @pid)

 

quote:

---

What if one has migrated the repository to SQL Server 2000?

-dao

---

FYI: The repository...

The data of the Usage Analysis is saved in the access database: msmdqlog.mdb under then bin directory of the AS.

There is no equivalent to ROWNUM in SQL. Take a look at this:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

May help if you create indexes on the text fields.

if not exists(select * from sysobjects t join syscolumns c on t.id = c.id where t.name = 'tablename' and t.xtype = 'U' and c.name in ('column1','column2'))

alter...

OK, for that you can use a sub-query, like this:

select count(*)

from (select name, c = count(*)

from tableA

group by name) Tbl

where c = 2

select name,count(*)

from tableA

group by name

having count(*) = 2

You can run the stored procedure sp_mshelpcolumns 'tablename' and in the text column next to the col_iscomputed will appear the formula.

The user that runs the sqlagent service must have access to the mapped drive and the drive must be mapped on the server. Try mapping the drive with the user...

Use the RAISERROR function like this:

 

if FirstDate > SecondDate

RAISERROR ('The SecondDate must be bigger than de FirstDate',16,1) 

I think you have the C2 Audit Mode turned on. Check this with the command: sp_configure 'c2 audit mode'

and see the last column (run value) if this is 1...

You have to create a trigger for insert on the table. Keep in mind that you have to configure the SQL Mail service to use the xp_sendmail command.

This sample is...

I think you have to check if the prevmember is not empty. The formula would be:

iif(NOT ISEMPTY([Fiscal Time April].prevmember),

(([Fiscal Time April].currentmember,[Measures].[Actual])-([Fiscal Time April].prevmember,[Measures].[Actual]))/([Fiscal Time April].currentmember,[Measures].[Actual])

,null)

Edited by - mdaniel on 02/05/2003...

Sorry for that, with dt_* I mean all stored procedures that begin with dt_