GilaMonster (1/8/2013)

---

Files that are copied when SQL is stopped or when the DB is offline or detached are static. Files that are copied while the database is active are not,...

GilaMonster (1/8/2013)

---

That's attaching without the log...

There shouldn't be a problem with the version difference. Have you tried it, though? That's the best way of finding out. It will depend on whether the...

Does this[/url] help?

John

Have you tried Full Text Indexing?

John

If this is an ad hoc query you wish to run against multiple servers, you might consider setting up a Central Management Server.

John

That sounds like a line from a batch file rather than a SQL script.

John

Craig

Don't shrink the logs, but make sure you're backing them up regularly. Search the web for "SQL Server Transaction Log Maintenance" for more information.

John

Roland Alexander STL (1/4/2013)

---

Don't think ALTER is the permission you want, as I think that applies to changes in the table's structure (I'll be corrected if I'm wrong, so stay...

Mark

Fair enough about the staging table - it was just a suggestion. Might still be worth considering on the output table, though.

If I may say so, the thing about...

It might be more efficient to do the update in your staging or output table instead of as part of the transformation. You'll need to test to find out...

If you have the option to clean the data in the database itself, rather than just the extracts, I'd recommend you do that. Use NULL where the value is...

If you've only got the one instance in your cluster, you could evict nodes until you're left with a single-node cluster. Otherwise, you're probably best building a new instance...

Why not? If you put this in...

That's more a VB question than a SQL Server question, and outside my area of expertise. You could try using MsgBox.

John