blandry (5/29/2009)

---

If I get the salary like an athlete, does that mean that I have to...

- Immediately start using steroids?

- Open up a pit bull fighting arena in my backyard?

-...

Edited the title. Please don't use tags in the titles.

Are you not backing up data? Or are you just trying to get schema data?

You can let people onto the publisher after you've enabled replication, and if the subscriber isn't available, you are correct, the distribution db/log grow until they can get to the...

I used to deploy changes like this using osql and a batch file. Now I'd use SQLCMD. The SQL Server install runs .sql files for some things using SQLCMD

Interesting. I thought most people would be against it.

For professional atheletes, it's a dog eat dog world, and they often go down as well as up. It just isn't reported...

sayfrend,

Thanks for the license update. That must be a change from previously.

I think Google is just as bad as Microsoft has been, but I also think that this is the way most companies behave as they get successful. People want to...

I tend to agree with Jefferey here, but I'd say that you want to standardize so everyone knows in a DR situation which data to restore.

If there is non-SQL data...

You'd need to log from the plan, not the job. The job doesn't log enough.

The big thing with remote backups is that any hiccup in the network will fail it....

Something like this:

Select POBuyersItemKey

, substring( POBuyersItemKey, 1, 7)

, substring( POBuyersItemKey, 8, 1)

, '5967241' + '|' + '19-62006-9-20'

from ISFfactory

order by POBuyersItemKey

Be...

I read that gem. Had to read it twice to be sure that I wasn't misreading things.

Shaking head here all the while. Some days I think I should just go...

Here's the thing. You can use a hash to try and determine if you have a duplicate. Not for encrypting.

What I'd suggest is that you use a separate column...

[drive by post]

I'm lost again

[/drive by post]

Try also printing out the intermediate values. Either with PRINT or a SELECT to your query results. It will help you figure out what's being compared. You can also...