take a look at :

 http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

 http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d yourdatabase /I /F c:\yourfile

rem SCPTXFR  /?  -  Command line help.

rem...

What's the goal of your function ?

- returning the "highest" membership ?

- returning the "last in sequence" membership ?

   (your current function)

- returning the "first in sequence" membership ?

maybe...

is the xp_cmdshell still open ?

exec xp_cmdshell 'net stop sqlagent' might be your weak spot.

Like Derrick Leggett mentioned, figure it out !

If your investigation points the symantics are OK, then you might use a case statement .

declare @col1 ...

- do you  have autoupdate-stats on (at db level) ? just run it once in a while.

We just run it once in a while (4 times a year) because autoupdatestats...

As you did find out, @@identity <> primary-key-info

afaik there is no way to have the "just inserted" primary key info returned, unless you write a query,... This however is...

I haven't used that combination yet.

We only use linked servers to non-sqlserver for problem solving. Only then the definitions are added and removed asap.

This is because we don't want...

Don't store concatenated stuff. It's not as adaptable as you might think.

Composite keys, don't have that huge downside.

If you want to have your newly inserted key returned by sqlserver...

not through sqlserver itself.

stop sqlserver service .

delete the mdf/ldf file

now someone is in deep sh..

Restore ?

follow the rebuildmaster procedure (see bol or ms-website)

is this db2 on os390 or AS400 or UDB on win/unix/..

you've already been advised to use sp_attach_db ... (see bol)

Then perform the checkdb

Any backup-files ??? (full / diff / log)

All ddl scripted nicely ?

Review you backup-schema !

oh please stay with CODD' s rules !

http://www.sqlservercentral.com/columnists/fkalis/coddsrules.asp

Basics of any RDBMS :

- know your relationships.

- use meaningless keys. It makes schema-knowlage mandatory ! and will avoid symantic errors !

-...

the rough way :

- Select  'exec sp_refreshview @viewname = ''' + u.name + '.'+ o.name + ''' ' + char(13) + ' go '

from  sysobjects o

inner join sysusers u...

http://www.sqlservercentral.com/columnists/sjones/performancemonitoringbasiccounters.asp

will put you on track.

- There are # of articles/forumthreads concerning performance monitoring.

this is also very usefull :

http://www.sql-server-performance.com/performance_monitor_tips.asp

create tabel mytable(

mybunch_of_columns ....

, tsInserted datetime not null default getdate()

, UserInserted varchar(50) not null default suser_sname()

) ...

This makes you don't have to change your insert-script because if the columns are not mentioned...