Miles Neale (8/22/2012)

---

I guess I have a question about this. The first thing is to insure that it is being backed up. Is part of that insurance proof...

Wow. I'm actually kind of amazed at the amount of vacation time present in this thread :-P. This is only my first programming job, and I'm quite thoroughly...

Seems to be a problem with the BETWEEN part of the query; it can't do a comparison to those numbers because you're passing an nvarchar type to the BETWEEN, and...

From what I understand, RESTORE VERIFYONLY will only check to see that the backup set is complete and readable, but it does not check the structure of the data particularly...

This is probably very general advice, but it's what's worked for me as far as learning goes :-). First, in your dev environment, try to create a giant lump...

Hm. Let's see here...

1x main production database

1x inventory management database

4x daily full backups of main production database, scattered around our servers and workstations (I'm quite paranoid about losing our...

Hehe, I'm just about to hit the one-year mark in SQL programming for a living, and while it's been great so far, the place I work at doesn't quite qualify...

Jared, we've got sales data going back to 2007, and we add about a thousand rows to the table daily at present, though that rate could increase as time passes....

Sorry for the late reply! Was quite tied up at work, and then more so at home :-). Luis is correct, we already have a table charting all...

Heh, during my initial job hunt for anything programming-related, I stumbled across several "entry-level" jobs that either required certification, 3-5 years of experience, or both! I was quite amazed...

Rough shot, but something like this should work:

SELECT LastName+CHAR(44)+FirstName

Adjust the LastName and FirstName as needed to match your column names; the SELECT is there for you to verify the results...

Ack. My business is currently dealing with just such a problem, and it's giving the accounting team fits. For one marketplace that we sell our goods in, the...

Well, my story probably isn't exciting, as there's not all that much to it, but I'll toss it into the pot :).

I started college with the goal of becoming a...

I might be completely wrong here, but here's a shot in the dark!

Try:

USE [DatabaseName]

GO

sp_helprotect

This seems to return a list of all logins for the database in question that have been...

Ack. Oh well, that rules it out in the specific scope of this question, but I can certainly toss computed columns around in a few other things. I'll...