I would say yes. Typically I only use chars for small columns that are either null or fill the column..state abbreviations, things like that. The additional overhead for a varchar...

Typically it's when you just can't get the performance any other way. Even then I'd look at using an indexed view or triggers to maintain it rather than relying on...

Where do you think you will gain performance? I agree that type checking isnt always a must have. Is it run time performance or time it takes to set it...

Good question. My hunch is that what you see is what you get. The advantage to declaring the parameters is you can be type safe on the client and it...

Seems like you're always going to have those problems anyway. A method I use for utilities is handle the one or two errors I see most often, other than that...

We're currently using SQL full text search for our search engine. Can you give me an example of something you had trouble finding, give me an idea of what to...

What file are you referring to then? Should be able to either BCP or DTS the data as long as the collations match.

Andy

In general those are good points, but in this case you probably don't want to size your system based on a single daily task. If you're consistently at those values,...

Totally agree with that point. Any type of simple obfuscation is worth doing to prevent this kind of casual snooping.

Andy

Yes, a trigger is probably the best, the alternative being to do a select against the table periodically (starting whereever you left off last). XP_Sendmail is not bad approach for...

Can you post the entire proc?

Andy

I agree. I'd put about much thought into whether I'd treat something as a constant as I would in an app. Have to weigh the chances of it changing and...

Are you trying to detach/attach, or just move data?

Andy

Sorry it took so long, had a few things to catch up on! See if this helps:

Dim oServer As SQLDMO.SQLServer

Dim oProc As SQLDMO.StoredProcedure

Dim oProcs As SQLDMO.StoredProcedures

Set oServer = New SQLDMO.SQLServer

With...

Installed it as the primary instance on my machine at home, installed Dev edition as the second instance, picks up both of them with no problem. Here is the code...