Hey, if we are going to rant, we might as well point out that the justification contains an incorrect piece of information as well.  It says that NOT LIKE causes...

Another reason I keep Northwind around is for testing backups.  I support numerous production and test environments and it's good for me to have a database that I can do...

No mention of the LARGE table anywhere.  Just one with 30000 rows.

:o)

/HAPPY FRIDAY

Brian,

If you want to avoid the computational overhead of running the procedures twice, you may consider using staging tables to hold the results and decide later whether to output them...

sree,

To answer your question directly, you can create a stored proc that will copy the file.  Look at the xp_cmdshell documentation in BOL.  This XProc will allow you to use...

Anthony,

I've recently discovered that the REPLACE statements are likely not the cause of the error.  I successfully restored a database with multiple MOVEs and REPLACEs.

I can't really see anything...

This is interesting.  While I have had success with NetBackup renaming a physical file during a restore, I've never tried to specify a different folder for the file.  I do mean...

Anthony,

Can you post the error messages from NetBackup logs?  also what version are you using?

I might be able to help. 

To answer his question I would just like to know what he wants to do.  If he's interested in further help, he could tell us why.

So...OP, Can you restate the question in...

This is fun stuff.  I had a problem with databases being set to auto-close.  Determined that databases created in MSDE default to auto-close.

I suppose Personal Ed. does the same. 

This method will work, but will suffer from potential performance problems as the table gets larger.

When a parameter is omitted, the query will evaluate each row of each column to...

And I have found yet another way to misspell sp_executesql

😮

Looks to me that all you have done is SET a variable to a value that contains an SQL statement that will copy the structure to a temporary table.

This will...

If you are trying to do this on an MSCS cluster, you should use the CLUSTER command with the RESOURCE sub-command.

/just in case...

hth JG

You might want to locate both instances of the executables, using a file search.  It should not be possible for two instances of the same SQL Server executable to run...