I did this last year on the system I took over managing using a server side trace writing to a file, then loaded the files into a table so I...

I let that be the programmers problem....

After overwritting their code once, they become much better at keeping copies of it =)

I also use ApexSQL Diff when there is code I...

phew

Good thing my title is Database Architect/DBA!

I've been in the reverse position. And left the company before the transaction was complete. Why? Excatly as pointed out before, lack of communication from the people...

Working with developers of all skill levels, in most places I have worked, I have found it to be safest to use stored procedures. That way at least when...

Makes no difference to me.

My main car for getting to work is a Ford Explorer, get about 15 - 17MPG (~13.5 to 15.5 L/100KM). At $4 a gallon I...

ok. Let me see if understand this....

You have a DR server

You restore a database from production to the DR server

The user in this database the application uses does not...

With sp_change_users_login there should be no need to drop the user. All it does is update the SID in sysusers in your database with the corresponding SID from syslogins...

I'm a little confused

ONe of the earlier post you say you write to \\machine\driveletter\directory, but later you say share. Which is it? Do you have permission for the...

Generally should not be a problem, and whenever you restart SQL it goes back to the original size anyhow. Only worry I would have about tempdb size is to...

I worked in a company where I basically was the Windows backend support, both databases and NT. Got trust right into it with next to no experience. Was...

Gsquared must be a gamer 😉

Can allways look at the syslogins table in Master database, should give you all that (not sure about the backup part of your question). Works in all versions up...

Hire a DBA / database architect?

Without knowing the structure of every table/query this needs done to, not much I can help you. But the general steps would be to...

Squarely in the no camp! Growing up on a farm I certainly can do most of it if I had to, but, I'd rather write a check and get...