Probably best to replace the sp_executesql with parsing of the string using builtin functions.

Cheers,

- Mark

Are the times on the servers in sync?

Cheers,

- Mark

Holy LogShippers Thomas! Is your boss going EE just for native log shipping? Has he ever seen how unhelpful it is when it breaks? Does he know...

If all databases are out of sync then it sounds like a prolonged network outage overnight. You may have to manually resync the databases from full backups (WITH NORECOVERY)

Cheers,

-...

use Linked Servers.

I suggest using remote servers for backwards compatibility only.

I'd offer more, but it may show up just how little I know about linked/remote servers.

Cheers,

- Mark

When you have a minus sign "-" in the pattern then SQL thinks it's a range. ie. "[)-+]" means any character in the range ")" through "+".

Specifying "[-)+]", as you...

What's a "TIME ZONE" datatype? I mean, in what DBMS is it valid?

Cheers,

- Mark

Someone has set the "show advanced options" configuration option ON for your server.

It could be someone with sysadmin access that you were unaware of, or more likely it was something...

Can you post some specific problem that you're experiencing?

Cheers,

- Mark

GETDATE() and GETUTCDATE()

Cheers,

- Mark

Try:

 

declare @retcode int

exec @retcode = msdb.dbo.sp_Start_job @Job_Name = 'Cancer Dataset CSV Output'

select @retcode

Cheers,

- Mark

You'll need to 1) rename the table 2) recreate the table specifying IDENTITY for COL1 3) insert data from the original table.

Note also that, to be an IDENTITY, the scale...

Use the ALTER TABLE statement to disable the trigger, then do the INSERT, then enable the trigger again.

Additionally BULK INSERT by default will not fire triggers.

Cheers,

- Mark

Try the following code. I tested it out in Northwind (hence the use of the OrderId column). To test the 2 scenarios, run as is, then change @latest...

1) install sql2k in corresponding drive/directory on backup server and bring to same service pack level as the live server (you've probably already done this)

2) backup master, msdb and all...