Sorry for the confusion. I was reffering to the select that was giving the headaches to the greener guys... so that's why I don't include the pin table in...

I usually don't include the pin table part in that function... It already gives enough head aches as is .

For those interested look...

I don't have time to answer your question in detail... but this should do the trick .

http://www.sommarskog.se/dyn-search.html

Function split - set based static sql :

--Start generating objects

IF Object_id('fnSplit_Set') > 0

DROP FUNCTION dbo.fnSplit_Set

GO

IF Object_id('Numbers') > 0

DROP TABLE dbo.Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1), dude bit...

Can you make a linked server from the production database to the msde instance?

If you can't :

Make a select into statement that extracts the valid data to a new...

How do you need to transfer the data??

Everything gets transfered?

Only new data gets added?

Data must be inserted and updated but not deleted?

I once uninstalled sql server 2005... took me 2-3 tries because there were still some componants installed... Maybe you have a similar problem!

I would be extremely surprised to find out that the system did this on its own... it's not like it does a search and replace on your hd and start...

Ask them to clarify what they need, then we'll be able to guide you on this... and do it only once .

Make sure...

I am not very familiar with those system functions.

Do they want you to run those like every day and keep the results in a history table and have that available for...

What do you need to audit exactly???

Data modifications, data access, historical data??

Depends what you plan to do with 'em in the proc.

Can you show us what you need with those parameters?

Great.  I'm still opened to other suggestions since I ain't no expert in the matter.

Quick and dirty :

Select * INTO dbo.Table2 from dbo.table1 where 1 = 0

That will copy the columns only, you won't have any dri, constraints, defaults, indexes or keys.

What error message are you getting?

What type of connection are you trying to make to the server (windows authentication or sql server)?

Is the server set to windows authentication or sql...