If losing a day's data won't matter, then Simple mode and full backups are enough.

If losing an hour's data won't matter, the Simple mode, daily full and hourly diff is...

I suspect most companies right now aren't all that keen on hiring someone without either experience or a degree in the subject, simply because it's a buyer's market in hiring...

update dbo.MyTable

set Fullname = replace(Fullname, 'Tommy', 'Tom')

where Fullname like '%Tommy%';

select @@rowcount as RowsAffected;

You mention multiple recipients, and a username and password. Are you sending the same username and password to each person, or does each get unique data?

Friday afternoons often are.

I just tried two vanity searches. Searched for "GSquared", then for "GSquared numbers". Trying to find posts where I've mentioned a Numbers table.

The odd thing was, I got...

Two questions:

Why a view?

Are the names in the name-value pairs from a fixed set of possible values, or truly dynamic? Are the names user-generated at runtime, or do they...

Is there a reason to not set up the XML source as a web service and just access it that way?

I keep two folders on the micro-SD card in my phone, one for administrative scripts (things like backups and index maintenance), and one for clever stuff (like string parsing, Numbers...

I give blood every 2 months (as often as allowed). Can't do the double-red thing, have a reaction to the anticoagulent used in that, so just give whole blood....

The problem isn't the FPU, the problem is the binary translation, and the limits of...

Yes, it's possible.

Is that a column in your...

The...

Does the report call a proc?

lrosales (10/29/2009)

---

thnks SSCertifiable

solution:

I did as you suggested as found out it was the admin, when the system runs the tracer it creates the procedure and there it lies hiden,...