If you look at the code of mdsb..sp_help_jobhistory, many things will become clearer 🙂

There is table sysjobservers that holds last run time of a job.

Timestamp is not a datetime type in T-SQL. It is varbinary(8). It's a row version, not last modified date, unfortunately.

gboehm (1/9/2008)

---

I’m trying to build an alarm logging system using SQL Server Express. I will have several tables each monitoring one alarm type, i.e., TABLE 1 EMPTY, TABLE 1 FULL,...

Yet another option is to use views to output data in desired format. In any way, idea of stripping date part in 500 columns is work costly.

Then it seems you have to use triggers.

and what is the error message? what is wrong?

I don't see any besides creating separate instance of server for that database.

This should work

set xact_abort on

begin tran

select distinct id, [Name], empssn into #tempEmployees

truncate table employees

insert employees(id, [Name], empssn)

select id, [Name], empssn

from #tempEmployees

drop table #tempEmployees

commit

HTH

Piotr

Since all conditions must be met (AND between them), I suppose it doesn't matter. Also, optimizer should be wise enough to chose best way of searching for information - like,...

after TOP 1 there has to be a * or field list

update: didn't notice that it was Oracle.. so it has to be ROWNUM then 😀

Hi b-boy

What do you want to achieve with this code?

declare @search_expression = select company_name from company

declare @max_distance = dbo.icddistance

You should use someting like

select @search_condition = company_name from company

second...

So probably it's the 'local system' account that wants to access this share. and local system does not have network credentials. maybe you could set up an FTP server on...

Hey Sandy,

Can you say what error was reported when you used "dbo." prefix? How do you execute script on remote server? How did you copy data to remote database?

Can you...

Hi Sandy,

I am a little confused - do you want to create schema test in database TEST?

What do you mean by 'uploaded database to Web Server'? Do you have script...

Look for sp_xml_preparedocument and OPENXML in Books On Line. There are some samples. In general, once you have document handle, you can use XML data as you were using data...