As the first post: there is no direct downgrade path

Backup user dbs, remove sql, install SQL, restore user dbs.

Not sure if restoring the system dbs is recommeded, but script all...

This can happen if the "originating_server" column in msdb..sysjobs is not the same as @@SERVERNAME (which is srv_id 0 in master..sysdatabases), perhaps the server has been renamed or msdb has...

"Aye": Would that be scottish then? Not that I am, spent many years there though.

I think you can "look" at the table definition say, in QA object browser, and know...

From a personal preference, I prefer PKs first (in key order if composite)

I've no preferences for the rest, apart from generally place large text columns at the bottom.

Cheers

Some thoughts:

I've used this setup before, 30 odd servers all cross-connecting using passthrough auth.

1. Server A becomes a client of Server B thus should connect using tcp. kerberos will not...

Did the poster not say "...started sql server..."

Not a database...

Unless they meant a database...

Can you not connect to sql or can you not connect to a database?

Another one that keeps it numeric..

OpenDataSource is adhoc and can be adhoc access can be disabled and has more overhead I'm sure

Look at sp_setnetname which would allow you to change the underlying network name of a...

I can't try this but modifying the best way to get a date only with no time

SELECT DATEADD(day, DATEDIFF(day, 0, <basedatetime&gt,...

Run this on your source server to generate a script for your target server.

This is a script we use. It won't do passwords though.

We use Security Account Delegation for pass-through...

The "you" was more of a royal you. I was just stating a fact, not criticising.

As for the 3 disks packing up, that's unlucky in anyone's book...

Unfortunately, if you have no backups there is nothing to restore...

How did you lose a stripe?

Did you have RAID 0 (no fault tolerance)?

Wow. if I remember rightly, you can't, but my memory may be faulty after so long away from 65

😎

It's the inner string, but I can't test it.

Try adding more quotes e.g

EXEC master.dbo.xp_execresultset '

SELECT

''''GRANT EXECUTE ON dbo.'''' + SPECIFIC_NAME + ''.....

Use a server OS?

Any other method (such as running SQL Developer edition) will break MS licensing...