None whatsoever. But there are a couple of reasons why you might not want that. Maybe the job is disabled and you don't want a big red X...

If you create the new file in an existing filegroup, this article may help you. If you add the file to a new filegroup, you'll need to move tables...

Have you tried looking at the wait types? You can use sp_whoisactive to make that easier (search for that and download it if you don't already have it).

John

Yes, since the file is already compressed, you won't gain much advantage from compressing it again. That applies to any compressed file format - for example JPEG. Try...

The best way to find out is to try it. But do you really have a query like that? If so, you might consider redesigning your application, because...

Yes, or use the Activity Monitor in SSMS or one of the built-in dashboard reports.

John

Brandie

They should be able to. For example, I could grant you permission to impersonate me and you could grant me permission to impersonate you. Never tried it, though!

John

No, I don't think so, but it's definitely something you should...

OK, just as a test, please create a new job with a CmdExec step and a command something like this:

copy c:\MyFolder\MyWorkbook.xls c:\MyFolder\MyWorkbook2.xls

If that doesn't work, it's looking like insufficient permissions...

Are you sure the identity was reseeded and that somebody (or something) didn't try an identity insert? Has anybody run TRUNCATE TABLE - that would reseed the identity?

John

Check whether that account has the necessary share-level...

When you run the package without scheduling, it runs in security context of the calling user - in other words, you. If you schedule it from SQL Server Agent,...

WHILE @CNT < @LOOPS

BEGIN

INSERT INTO #TempTableThatYouveAlreadyCreated

Select * from check_active_sessions

SET @CNT = @CNT + 1;

WAITFOR...

If I understand correctly, you want to return the third row because the price changed to 30 on 1st January this year and hasn't changed since. Is that correct?...

Sounds like a job for Secure FTP. Clearly it's not acceptable for them to receive data by e-mail, and it's not going to be acceptable (or at least it...