I'd agree that networking shouldn't be a big time sink in your life. However networking isn't a daily thing, or doesn't need to be. Touching base with people you know...

What's correct? You can parse a statement to see if it's syntactically valid, but that doesn't mean it will execute as you want it to execute. The only way to...

Developers do need a sandbox, but they also need to maintain control of their dev environments. Too often they don't know what they changed to get something working, or they...

The functions of service accounts work with or without an AD domain. The difference is without they are limited to accessing the local machine only. I haven't seen anything about...

You'll have to give details as to what "performance problems" and "not working right" mean. We can't help you solve the issue if you don't explain what issues you are...

It sounds like you need to:

- install SQL Server

- attach the databases

- rebuild logins if you cannot attach master.

I'd say SSIS would work, but I'm not sure what SSMA is.

If you have a package, then one way to do this is pass in the name of the db...

SQLSentry has a great tool as well.

Backup log yyy to disk = xxxx

Copy xxxx to zzzzz

THe Agent can instantiate a Command prompt batch file that does the copy. Powershell or VBScript can handle this.

Restore doesn't run under a user ID. It runs under the service account. That account might not have rights to that path.

this error occurs when you try to insert a value for the identity column in a table that has the identity property set.

If you set up replication, do not replicate...

The check should work

if exists (select from ... day = day, month = month, etc.)

Then I'd disable those not used for 90 days, but I wouldn't remove something until 365...

you could easily check to see if the person had already logged in on that day by checking user name, day, month, year before inserting.

However, are you trying to just...

I would second GSquared's suggestion.

Yes, use the SQL Server 2008 version