In your expression, there is a space at the start of the string. Is that how your data looks?

John

Oops - double post!

If Simple is involved anywhere then your backup log chain is going to be broken.

Full -> Simple -> Full: take full backup immediately after reverting to Full

Full -> Bulk Logged...

Yes. Either switch to Bulk Logged instead of Simple, or take a full backup as soon as you switch back to Full.

John

If the server you're trying to connect to doesn't listen on port 1433, you'll either need to specify it in your connection string or create an alias on the computer...

zedtec (4/1/2014)

---

If I was to use only one job will the trace still start and stop at specified times?

If using two jobs would I add my trace script in both...

The job will start at the time specified in the schedule and run until it finishes. If you're running a trace, you probably need two jobs - one to...

Have you tried the Starting at and Ending at fields in the Daily frequency section?

John

Well, at least five people have asked for their money back.

You can argue talk all you like about what...

I'm afraid I don't know what you mean. Please post your code.

John

Use RAISERROR in your CATCH block.

John

Have you read the page on CAST and CONVERT in Books Online?

John

The first one is ANSI compliant and so is usually preferred. I prefer it also because it keeps the join predicate separate from the WHERE clause. Finally, for...

Probably best to use ALTER DATABASE to change those file paths to drive letters, then. Make sure you have backups first.

John

Peter

I don't know what's going on here. If you do [font="Courier New"]SELECT * FROM sys.master_files[/font], do all the file paths show as drive letters? If so, something is...