The following process was developed in 2000 environment, but should work in 2005 if xp_cmdshell is enabled.

Create a stored procedure on server A that dynamically creates the T-SQL necessary to...

I wholeheartedly agree! Codes of conduct are born out...

I didn't see many movies this year, but one that actually was a lot better than I thought would be is Seven Pounds. Dark Knight was good but not sure...

How did you pull that off? 🙂

Steve - when I develop the first transporter device, you can be my first human test.

Good article! There's nothing worse than trying to learn a database that has inherent encryption. 🙂

Good article.

Here's a basic question:

How does one verify which physical array the database files and backups are located on in a SAN? I suspect that I have my backups located...

Merry Christmas to all and a prosperous New Year!

I must live a sheltered life. I haven't seen half of the movies mentioned. My votes would be:

1. Iron Man computer

2. The computer system used by the bad guys in...

mhaskins (12/3/2008)

I don't...

I think you also lose a sense of ownership when jobs are outsourced. Even for basic functions, you lose that sense of someone constantly asking "are we doing this...

Nothing like a good trick question on a Friday morning to keep you on your toes!

Yes to both. I'm guessing an error would have been thrown if either of these is false.

After looking at this further, if I remove owner reference for the stored procedures, I am able to execute all 28 lines at once:

Does NOT work:

GRANT EXECUTE ON dbo.storedproc1 TO...

I always had it in my mind the main reason companies move data centers to "remote" locations is for disaster recovery, and that job creation, tax incentives, etc... are just...