select *

from master.dbo.sysdatabases

where DATABASEPROPERTYEX(name, 'Status') = 'OnLine'

Read about sysdatabases system table in BOL.

Everything is there.

So, what's the question?

Is it "bcp" command you are after?

Are you sure the script you posted is SQL, not VB?

If those quotes are in column names then use [] for column names.

If they are in data you scripted then duplicate quotes when you are scripting data.

Like this:

select REPLACE(ColName, '''',...

Query Analyzer.

Plenty of options available in "New" submenu.

And right-clicks on objects in Object Browser (press F8 to open it) will help you to build scripts you need.

I'm afraid LDAP lookup times slower than retrieving next row from recordset.

So, using cursor or WHILE loop not gonna slow down your procedure.

Probably you need to revise the whole design...

Set up a trigger FOR DELETE to record deleted records + some audit information into another table.

NEWID()

You must declare your variable as OUTPUT parameter for sp_executesql.

I believe it's the only bit you're missing.

Yes, it works.

Just today there was a reference to this article:

http://support.microsoft.com/kb/314520

Read BOL about sp_executesql.

Wouldn't it be easier to check for existence BEFORE?

IF Object_ID('v_guk_welcome_letter_active_member') IS NOT NULL

... your script ...

Why you decided you need function?

What's wrong with procedures?

----------------------

Create procedure aftest

@username varchar (10),

@EmailExists bit OUTPUT

as

DECLARE

@sql varchar (500)

SELECT @sql =

'Select

mail

FROM

OpenQuery(ADSI, ''SELECT mail...

Condition

where a.field1 = 1

and a.field2 = 2

makes all rows from table1 mandatory, so LEFT JOIN from second query does not work.

Not sure what do you really mean but probably...