Judging from the error message, the service account for SQL Agent has problem accessing the AD to validate the user. 0x63 = 110, and NET HELPMSG 110 says:

The system cannot...

It's not strange at all! That's how we sort in Swedish(*). In...

If you want to collect this data for a specific execution, you need to save the data before execution into a table, and then after execution read the DMV again...

SELECT n.software_manufacturer, n.productname, n.productversion, d.licensable

FROM dbo.newtable n

JOIN dbo.datalookuptable d ON d.software_manufacturer = n.software_manufacturer

...

Your query is very difficult to read, because you don't prefix every column, and therefore it is difficult to tell where they are coming from.

It also suffers from having...

Here is a query that I have canned. It's part of a tool, and the purpose is to return information about all user-defined types. (But I realised today that it...

There is something which is amiss here. The code you sent me had no parameters or variables. However, the plans you posted has:

...

FILESTREAM data can be exposed to remote clients on a...

You think you know. Unless the file is produced by a device, it is almost given...

I said that you don't need the inner TOP. The outer TOP is sufficient. Hm, it may have an interesting effect on the query plan. Try it!

And from where are you running that query? Not SQL Server Management Studio I hope!

The problem is...

It should not cause a problem if you stop playing with fire and stop using unsafe date formats. Stick to YYYYMMDD, which is always interpreted the same way.

So in two...

You don't really need the inner TOP in the UNION ALL query.

But as Kevin says, the optimizer is not perfect, and it does not shine on queries with OR. I've...

aykut canturk (8/21/2013)

---

What I confused about is unicode chars. I need all eurepean characters. French, German, English, turkish etc. But not chinese, japanese. only latin characters. should I use nvarchar...

So what you error message do you get?

Generally, SQL Server does not support databases on remote servers as I recall.