A "whole system" kindof question though:

Where should the data get decrypted?  For SSN's I almost think it should not be decrypted, but the user input should be encrypting and the...

Question my dad asked:

So where is Booganville?

I replied -- no such place, only to be presented with a globe...

Look around New Guinea...

Higlight for the answer...

Question:  Referential Integrity?

When you have these cross-database (and linked servers, etc), how do you maintain referential integrity?

eg, bbdpres:

We have an environment for reporting here that needs to use dynamic...

>Wouldn't having the "code more organized" remove most of your naming conflicts?

>I would think the downside of having everything in one database is a lot smaller when you consider...

I'm not sure what the problem was, but we solved it by changing the login from "Use connection's credentials" to "Use No Credentials".  I'm still fuzzy about why an excel...

Why not use NT Authentication?

That would let you use all the current enterprise tools for maintaining and controlling passwords (such as expiration, min length, etc).

Yes, you need to manage the...

I agree that this is pretty nifty; I use a similar getup for generating reports using SQLMail.  That said, I've found some problems using the idea:

1. No dependencies -- The SQL...

About primary keys:

Are they still a good idea no matter how complex they become or how irrelevant they are?

Example:  I have this calculation table (when used with joins and group...

But beware the lurking exception:

If you feed it '1,2,abc,5', the code will fail.  Much better than injection, but make sure the code will not cause damage if you feed it...

Thank you very much; every day I find I know very little about sql (Mainly a C/C++ dude).

Hey RonKyle, could you post an example of the join that you're talking...

I like RonKyle's solution -- its one I haven't seen before.

But why not a query like this:

select * from customers where

((@countryOP='bg' AND country like @country+'%') or

 (@countryOP='eq' AND country = @country)...

I read a column about this type of thing where it was called a "Worst Practice".  THe issue with calling an outside program from a trigger is that if...

I like hashtables (and use them when I need quick 1-1 lookups), but for UI elements or other sequential-access type things, why not just keep the dataset/datatable around as long...

[From the article]

Which rolls back your update. Which may result in an error to your users or worse, removing a bunch of data they updated and not correctly telling them...

Ok.  I think I muddled through it.  This doesn't sound optimal, or nice, but it works.

I was trying to do exec @result = sp_executesql N'exec xp_cmdshell ''dir'''

But that would always return 0...