Could be a timing issue. I had something similar with the app that gets something from the share. If a user logs in to the computer that is not...

You can use WGET utility in the script, it will place the downloaded file to your local hard drive and then the next step of the job will be...

Hi Sean,

This is what it says: the process probably can not access the domain controller to verify the identity of this person. It can happen if Agent or SQL Server...

Hi,

Linked Server Local Login is mapped to the remote login.

How is your linked server logins are set up?

I would create 2 Windows Global (or server local) groups, add developers to...

Thanksgiving also equals BIG HIGH SCHOOL FOOTBALL

For those who don't celebrate Thanksgiving, this is Football as in American Football, not as in you hit the ball with your foot, but...

Richard,

Drama starts after appending!

Now with automatic appending they will have to write another 100 lines of code to prompt for the timely cleanup, checking for the file size, drive space,...

Was not >> an original UNIX command?

As rightly mentioned by Tao, try to run it with ANSI_NULLS OFF:

set ansi_nulls off

IF(NULL IN (34, 35, NULL))PRINT 'TRUE'

IF(34 NOT IN (35, 36, NULL))PRINT 'FALSE'

and you will get a completely...

In 2000 all objects are in sysobjects and the definitions are in syscomments in the text column

Yes it is.

Management Studio is just a client tool. Your queries are going towards the actual server which in your case is of version 2000

Did you try to run the plan manually and not as a job?

It may happen that the account that is running the job does not have permission to delete files.

Or...

The reason could be that you are running SQL Server 2000 that did not have this table.

Please, confirm

David,

You do have a choice. You can run DBCC Checkdb at the low usage times, like at night or middle of the month or when you determine the lowes user...

Hi,

There are 2 types of files, yes. But there could be more then 2 files - they roll over:

http://msdn.microsoft.com/en-us/library/bb630339.aspx

I normally use

http://msdn.microsoft.com/en-us/library/ms186265(SQL.90).aspx

sp_trace_setevent (Transact-SQL)

that lists events with the last event number 202 with 10 of them reserved, total number 171. The question was how many of the events are...