Reminder, SQLAgent is a user. this wont help you do any jobs.

1. Is the "setup" file is still good to use if my sql server is patched to SP2 after installation?

If this is one of the system database files that are...

I do not have an automated function, however... This may work until you build one or someone assists with one. Make sure and set results to text.

For tables:

sp_msforeachdb @command1 ='use...

If you're trying to load this on test from production to test... I'd either say build a like environment to get a proper test or I would clean install SQL...

Do you show any errors on the SAN side? is it dropping the luns due to too much data change or a journal getting full? If it happens after some...

I believe they have a SQL Jobs area here. This isn't exactly the right forum to post these on.

The services start and run, SQL is up, you cannot login?

I would use the SA account and verify your account permissions. If SQL is up and running, I cannot think...

Let me see if I understand. You cannot login to SQL using windows auth. You can login when you login with the SQL service account. you're using that account through...

If it's the application account, DBOwner may be more expected depending on how it reacts. does it create tables, delete items, insert, update, drop? I agree with least privilege, though...

When you say it doesn't work. What part of it? Social networking seems to be a working idea in most cases. Larger companies or even tight knit small ones may...

for us, we use an MSX server. each set of servers in that cluster or the target of replication get pushed those jobs hosted at the MSX server level. When...

I was in your same exact shoes 6 months ago. I have my MCITP 08'and MCSE 12' certs. I was having trouble finding a DBA position. I got lucky and...

you could also just not schedule anything during these times, set it to 1:59, or even just know this is something to watch for.

It is enterprise only, though you can still use a multi-table setup instead of partitioning a big table.... though i can only see that being worse if the current dba...

difficult question. I guess... it depends?

Some manage well more than just the database.

Here, we fix anything that is down, broken or acting up. Work on performance tuning when we have...