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...

You could put in a new step one and use the On success and On failure actions of the new step to govern what the job does next. That...

SELECT ID

FROM #John

WHERE

CASE

WHEN ID NOT LIKE '%[A-Z]' THEN RIGHT('0000'+ID,5)

ELSE RIGHT('0000'+ID,6+LEN(ID)-PATINDEX('%[A-Z]%',ID))

END < '00020'

If you're going to use it like this, you need to make sure you understand exactly how it works,...

You're on the right track. This should work:

CREATE TABLE #John (ID varchar(4)); -- if your column is char instead of varchar, this won't work

-- Constraint to check numeric characters...

Since they're cumulative since SQL Server started, you'll...