Do you want to pass an array? like exec  'ACJG,12547896,2006/01/01' comma or something seperated.

Then your stored proc must be like this

CREATE PROCEDURE add_dependent

@incomming_array varchar(255)

as........ 

Working with arrays IMHO should be avoided...

IMHO. Depending on timelines etc. Doing it that way will mean that you have to attach the mdf. file twice and at 4 TB will take very long. Would it not...

Hi

You can use this

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[table01]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

truncate table [dbo].[table01]

Tip

In EM highlight all of the tables and generate a script...

Just a shot in the dark...I need to see the tables in the database.

However did you try to look at the tables in the database as each column in a...

Your post is not complete.....

try select  HOST_NAME()

Don't know how to get IP

I would put the view in a stored procedure with an input parameter called @Show_links

Then apply the following logic...

If @Show_links =0

then

Select distinct......

end

If @Show_links =1

then

Select .........

end

I hope this helps

Also check your file extention .MDF  vs .NDF

I have also had problems with my eyes burning. Many years ago I went to an optometrist and he said that I had no problems with my eyes. He then gave...

Mike ,

I now have the 3rd party dll problem. I don't know too much about the 64-bit platform and I need to register a 32-bit dll. There is no

Most days am am just stupid but today I am an idiot. My user is a SYSADMIN but after I read your post I simply gave my login access to...

Thanks. Seeing that it is a totally new rebuilt platform and new istallation with no funnies loaded. Maybe this is a MS bug? Will make a call for MS to...

Hi

Thanks for your reply. We have SQL 64BIT SP4 loaded on a clean system and the xp is   master..xp_cmdshell.   

We are running WOW but don't know how to workaround

Hi,

If the csv file is not to large and you have not imported it you could use the following....

DELETE dbtable

FROM dbtable AS d LEFT OUTER JOIN

OpenRowset(

'MSDASQL',

'Driver={Microsoft Text Driver...

HI, TRY THIS.....

Before you run it maybe you can change the delete to select * to test.

DELETE dbtable

FROM         csvtable RIGHT OUTER JOIN

                      dbtable ON csvtable.id = dbtable.id AND csvtable.supplier =...