Ssssshhhhhhhhhhhhhhhhhhhhhhhhhhhh!

you might wake me up

Orphaned users are easy to fix:

-- show users not mapped to a login

EXEC sp_change_users_login 'Report'

-- map database user OrphanedUser to Login OrphanedUser

EXEC sp_change_users_login @Action='Update_One', @UserNamePattern='OrphanedUser' , @LoginName='OrphanedUser'

Using one of Jeff Moden's splitter functions

DECLARE @pString VARCHAR(MAX) = 'BUILTIN\ADMINISTRATORS: [System Admin]YES;[Security Admin];[Server Admin];[setup Admin];[Process Admin];[Disk Admin]YES;[Database Creator];'

DECLARE @pDELIMITER CHAR(1) = ';'

;WITH SPLITS AS (

SELECT ItemNumber = ROW_NUMBER() OVER...

It could be due to two machines on the network with the same name.

http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/343e15a5-a577-437c-9693-66e303f0c0eb

Check your event log, see if you have the kerberos mentioned in the above.

Also try google for...

Already home and cracked a bottle 😀 (on this side of the pond)

L' Eomot Inversé (5/11/2012)

Tom Brown (5/11/2012)

Hey - I can apply this...

L' Eomot Inversé (5/11/2012)

90-10 rule (Sturgeon's law - actually Sturgeon's second law: his first law is the...

Another reason I found for this error was spaces in the filename or path

sys.fn_trace_gettable('C:\Documents and Settings\tbrown\My Documents\share\Trace20120403 1200.trc', null)

caused the error, whereas the same trace file renamed

sys.fn_trace_gettable('C:\temp\Trace20120403_1200.trc', null)

worked fine. ...

Koen Verbeeck (3/23/2012)

<pedantic>

<sarcasm>

Apparently some site where you can find forums where people will give you free advice instead of doing anything yourself...

<\sarcasm>

^^No closing tag for...

We use the CLR because of the complexity of the processing. It probably could be written in a cursor - but it would be a maintenance headache, especially as...

Just for completeness here are a few things to try if your CLR performance is unacceptable.

1) Despite the title of this thread, DO use SqlBulkCopy - its much faster than...

I should have figured. The post was a month old.

Just getting into CLR stuff myself, all sorts of complexities to keep me occupied 😀

If you select the Build...Deploy option in VS (at least in VS 2010), then Visual studio creates the deployment .SQL in the bin/debug or bin/release directory along with your DLL....

Thanks for the suggestions but, ...

well I'll just have to eat crow on this one :blush:

Turns out I had my timing code in the wrong place in the CLR,...

A good week is when i get unexpected gifts: I did a little website work for my brother-in-law.

(though I may have hinted about the WPF book)