How well does it run for you without the cursor? How many files are you deleting when using the cursor per database?

I've not used this inside a cursor, I...

The_SQL_DBA (10/17/2008)

---

Well, for me there was never...

And how often do you test recovering from those tapes? Nothings worse than going...

Denise McMillan (9/22/2008)

---

Yes it's part of the file name. I'm still struggling with the syntax. Can you see what's wrong with this:

BACKUP DATABASE CE10 to disk = 'c:\mssql\backup\ce10_db_...

You can restore a 2000 backup to a 2005 server. That's a common upgrade path for many...

Something else is still going on.

Look up the RESTORE command in Books Online...

Make sure that the database isn't highlighted in blue when using the GUI to restore.

Stupid, I know. But if you left-click the database in question you want to restore,...

The basic rundown is this:

Run SQL setup and remove the node you want from the sqlserver-perspective of the cluster.

Start Cluster Admin and evict the node you want from the MSCS...

Mhhmm, installed my client tools, BIDS and BOL yesterday afternoon alongside 2000 and 2005 tools. No issues other than an awfully long set of installs for VS SP1 and...

To add..

When you create multiple files (in the same filegroup) you will increase the number of IO threads that the query will use (1:1 ratio).

So if you have one FG...

One warning with VS2008 non-SP1 (which isn't RTM till next week)...

http://sqlblog.com/blogs/denis_gobo/archive/2008/08/07/8261.aspx

Also have an '03 EX500 that is in the process of being converted to a LW-twins racer for next year. I'm planning on running the Formula-40 (gotta be 40...

Joshua Chapman (7/11/2008)

---

My commute is 65 miles each way by motorbike, but with 165 stallions and a twitchy right hand the journey is quite fun. 😀

The only problem is...

As I suspected...the tabs are being converted in the scriptbox when submitted.

I'm not sure what to tell you except to do a search & replace on the tab character. ...

The scriptbox appears to add characters (or uses a diff charset) for tabs.

What errors are you getting?

Edit:

If you are indeed only parsing it and not compiling it, it will generate...

It might be the extra characters that are 'added' to the script when posted.