DavidB,

Running from QA I get the same results as Jags2001. It's only if I try to manipulate (insert or update) a table column declared similarly that I get the...

Yes, that will work if the string has just one set of multiple spaces. eg.

SET @r = 'A  B'

But it has no effect if...

If SQLAgent's daily scheduling works the same as others (eg. hourly or every minute) then the answer's A. It will skip the invocation.

I can't see any reason why daily...

I suggest not explicitly naming the PK constraint. Let SQL come up with a unique one. Eg.

 

ALTER TABLE #ThisTable WITH NOCHECK ADD 

PRIMARY...

Don't forget to "hide server" too. Or, block UDP 1434 at your firewall.

Cheers,

- Mark

Given your SP code, a view and a subsequent select could be:

 

CREATE VIEW vTest

AS 

SELECT *,

    [cost(tid)] = 

  ...

You can possibly also run a profiler trace looking for "Log File Auto Shrink" events.

Cheers,

- Mark

It all depends on the complexity of your "cost" function. If cost(tid) can be implemented as a computed column or a set-based subselect, then it's entirely possible that a...

Although I always recommend a dedicated SQL Server, I couldn't find any concrete statement either, except for one comment:

quote:

---

If you...

I tend to agree with Andy. Maybe the time on the server is wrong, OR it temporarily gets set wrongly overnight, causing SQL Agent to disable your job. ...

Hi Charles,

According to BOL...

quote:

---

Once a licensing mode is set, you cannot change modes. You can add device or processor licenses...

Why don't you add login c as user c in database b. Give it the same privileges as user e.

Preferably, in database b, add a new role...

I'm surprised this question has caused so much debate. Whereas other QODs have had "missing information" (for example: the squillion QODs I've got wrong), I thought this one had...

Leonx,

a cutdown version of what you might be looking for is:

 

create table TblTree (Node INT UNIQUE, ParentNode INT NULL)

GO



insert TblTree select 1, null

insert TblTree...

oops

Cheers,

- Mark