So you're assuming they will have a box running SQL? Or if they don't, will you rely on MSDE?

Andy

We don't mind beginner questions, all we ask is that you try to figure it out for yourself first! I'd recommend you that you post bite sized questions that are...

A partial explanation is that without an explicit order by you're not guaranteed to receive the data in a particular order regardless of whether you have a clustered index or...

Im surprised your installed didnt pick up any other dependencies. I'd suggest starting with Depends.exe (including in Visual Studio) - point to sqldmo.dll and it will show you all dependencies....

You can either change the outer single quotes to a double quote, or you can replace the embedded single quote with two single quotes, 'Scott''s'. I prefer the second method.

Andy

The first thing I see is that you're assuming only one row is modified per trigger. You either have to use a cursor or convert your auditing code to do...

Sounds like the trigger. Are you doing a rollback somewhere, or maybe it's an instead of trigger? Post the trigger code, we'll see if we can help you figure it...

How about using XML instead? You can get it in a single select, no cursor. Should be able to load it directly, or you could apply a transform to convert...

Jeff, it one of you transaction log backups is bad, you're in trouble. You'd end up being able to restore up through the final good one and you'd lose any...

Interesting point about the multi server admin. I only have two right now, not a lot to maintain! Is the consensus that if the bugs were fixed or at least...

Never tried anything close to that size. You wouldnt think it would hurt anything. Worst would be that with so many objects if you're really using them all will be...

You might want to look at objectproperty and databaseproperty functions.

Andy

Not sure that is going to give you exactly what you need, even though you have the transactional pub stopped how will you know exactly which transactions have been applied...

What if you declare an input parameter as text, wouldnt it be accessible within the proc? Why don't you build the string on the client and actually send over as...

Before we venture too far, why is it you cant get a folder with the needed permissions? Seems like that is the easiest way by far to resolve the issue.

Andy