I have to disagree with phbarn, and agree with the sound advice given my Michael Earl.

Without cascade deletes, accidental deletion of a parent is stopped in its tracks. I've...

I'm a little confused here.

In your first post, you said you wanted to persist all new objects, but in your second post you say you've written a script to...

SQL Server doesn't store the data in that structure. I think some other RDBMs do.

SQL Server stores everything (tables, indexes, procedures etc) inside a single file (it can be more...

Clustering places no restrictions on the recovery model you need to use, so you can still use SIMPLE if you want.

Just understand that setting the recovery model to SIMPLE is...

I would suggest you look at doing this with a virtual machine... just keep all the VM files on your external drive.

You then just need a copy of the VM...

Are you sure?

I'm quite happy to be proved wrong, but a single cluster can host multiple virtual instances, and I always understood that there was...

Try this:-

select substring(clinic,1,charindex(':',clinic)-1),

substring(clinic,charindex(':',clinic)+1,LEN(clinic))

from PS_TestForOnline

Is this what you are after?

select adr_club_name +

...

I don't really understand that statememt... where did you see it?

The checkpoint process has nothing to do with...

Yes, you can use the Simple recovery model... the transaction log is only truncated after a checkpoint AND all transaction marked for replication have been processed.

Does the function exist in the subscriber database?

If not, create it there and try again.

Almost every post I have seen from Celko has been arrogant, dismissive and insulting.... what...

exec @NewIP = dbo.sp_Woodside_String_IP_Selection_V1 @IP

The syntax you've used there populates @NewIP with the return code from the stored procedure (or 0 if you have no RETURN statement in the...

It isn't just the hackers you have to worry about... the car manufacturers are up to no good with their own car software.

Peugeot in Europe were found to be incrementing...

I think you're all sad, and need to get a life 😉 (only joking)

If I could give up work, I'd be overjoyed at not having to touch SQL ever again.

I...