one parting thought - since you ran a shrink operation against the database itself at least once (I'm assuming that last shrink was against the LOG and not the database)...

No - over here you get points just for opening your mouth. As you can tell - I can barely keep my mouth shut...:hehe: Gila on...

John Beggs (2/6/2008)

---

@matt-2

I think you'll find that if you want to do a "true" (well not true, but closer than it was) "right sizing" of the comparison, then you'll need...

You're correct - "Oldest non-distributed LSN" means replication is still in place. It won't truncate the logs that haven't replicated.

Since it sounds like you DON't want replication on, turning...

Jeff/Jacob:

first - Jacob - very nice. Good solid method for handling a common request.

Jeff - I'll chalk this up to being the forever contrarian... But the comparison gets...

I would forgo telling the import that it might have quoted text delimiters, and deal with them after the import.

You should be able to remove the leading and ending quotes...

If it's a windows user - you can't set a password. Windows users use Windows authentication, so SQL doesn't get involved with passwords. If you need to set...

Open up Object explorer (F8 if it's not already open). Expand the server name, and under databases, should be the word "security". Expand that and you should see...

if you've defined the bit field to be nullable in SQL server, and have in fact allow null values in - Access will have all sorts of trouble with it....

Keeping Grant's recommendation in mind - there are also some options like FAST_FORWARD you might care to turn on. That being said - it's likely that the slowness is...

Excel data cells can only accomodate 32767 characters. You're going to have to break that up if you plan on putting that into Excel.

Is there any way to dummy up a little sample data? It's REALLY hard to help you with no concrete basis to start from: the conversation is at such...

If you have a web service - why have it dump the stuff to disk - why not insert them directly into a table of all of the XML documents...

I rarely am afraid of the C-level folks when they ask for an opinion, since for most of my career, they've been so far up the food chain. The...

iceheartjade (2/5/2008)

---

I see all pros here. Any cons? Like performance wise. Will it be faster to load the table without constraints? I don't believe without foreign keys...