The last entry in the (Event Viewer) Windows Logs.Application says this:

SQL Server is now ready for client connections. This is...

Sorry, missed this response.

I named the instance Express2008 when I...

The Windows Logs.System tree node says

Application popup: SQL Server :

The XML says this

- <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

- <System>

<Provider Name="Application Popup" />

<EventID Qualifiers="16384">26</EventID>

<Level>4</Level>...

John Mitchell-245523 (1/15/2015)

---

You see where it says "Operating system error = 32"? If you don't know what that error code means, go to a command prompt and type [font="Courier...

Exactly the same problem with the service stopped (via services.msc), still nothing in the ERRORLOG

Hi,

Yes the service is still running.

Made a little of progress. I explicitly named the instance like this

sqlservr.exe -m -s "Dev\Express2008"

This forces it to use the...

Hi,

Thanks for the response. I doubt it to be honest, pinging the server reports that it's on an Alpha Server running OpenVMS.

The ODBC driver is by Attunity who...

heh I know what you mean. I have been in at least one place where the intentionally gave me totally bizarre stuff like this to see how I would respond....

School was over thirty years ago...

I agree, they are strange requirements but in thirty years of working I've come to conclusion that in your second week at a new...

Hi,

Thanks for the response.

#1 - Ok so if I deny access to all the current views via this new role and then someone creates a view in...

Thanks for all responses.

Hi,

that seems to work but I...

Good point, thanks.

It works now, not sure what was wrong. :w00t:

Do you not just have to set the checkbox 'Enable Identity Insert' in the Column mappings dialog box?