Sounds like the machine SQL is installed on is having problems authenticating against the domain, don't think it's an issue with SQL itself.

Whether that's the machine itself being dodgy, or...

No problem mate 🙂

I don't think you need the machine name in there either.

Good error box!

Does this help? (From http://msdn.microsoft.com/en-us/library/ms162819.aspx)

"Important

When starting an instance of SQL Server, you must use the sqlservr application in the appropriate directory for that instance. For the default instance,...

Did you get anywhere with this Paul?

Couldn't find a way to do it, perhaps create a dummy file, or grab another FT index file from somewhere & rename it?

dwain.c (5/18/2012)

---

I don't recall that being the error I was getting but since it is pretty explicitly saying that I was trying to be a naughty boy, I suppose I...

Nice question, thanks.

Nice one. Got it by a process of elimination rather than actual knowing the incorrect one!

No problem, let us know how you get on!

You could use Access, I think it'd make more sense to grab SQL Server Express (it's free!) and play with that, much...

ljvarga (5/11/2012)

---

(small background info to see where I'm coming from)

Right now I'm only doing Select queries to the database (is it possible to screw up the live data with a...

No way for the user to go through the original table population procedure again?

Changing to Bulk Logged recovery mode might help with the disk space required, although not sure if...

ljvarga (5/11/2012)

---

Is there a way I can create a template (ie. declare the stuff from wip like hours and dates) and test with an if statement where if the employee...

Haven't really looked at the code properly, but I did notice this:

Aside from its clever use of use of SQL Server features, it relies on a very important insight into...

You need to give your derived table an alias (I've used "tbl" here, but anything will do):

select *

from personel

where maas = (select max(avg_sal)

from (

SELECT AVG (maas) as avg_sal

from personel...

Nice question, thanks.

Always good to know the difference in behaviour between ISNULL & COALESCE, can be a gotcha!