I built a utility based on some code I found a few years ago. It captures blocking info, including blocker, blockee, what they are running, time, spid etc... sends an...

As I recall, you can export & import them...

Is the BUILTIN\Administrator login still there ? If so, and you are an admin, then you should be able to create new accounts and assign permissions.

Steve Jones - Editor (12/4/2009)

---

It seems that quite often people move sideways in a company. The best thing seems to be to get any type of job and then try...

Are you wanting to import and convert to SSIS at the same time ? The tool I referred to just imports them as DTS running in Legacy mode.

Yes, better to start a new thread, not hijack this one. See my reply in this other thread...

I think I used "DTSBackup2000" tool. Free download, and pushed 100+ DTS packages from 2000 to 2005 with just a few clicks.

Do you have SQL 2005 or 2008 installed at home ? Set up a simulated environment of databases, start replicating data between them, run backups, corrupt a database, practice...

I would think you'd need to provide more specifics about the software & platform to get much of an answer.

Resolved. See Updated in Post #1

Thanks for all the help.

I agree about not putting the email in a trigger.

Here's the email syntax you can run from a job:

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'MyName@MyCompany.com',

@query...

MAK-1128556 (12/2/2009)

---

we are using the 2005

How to schedule a job for 7am and 7pm, i set up to run every 12hrs starting from 7pm and end on 11:59am

what should be...

I tried to install a separate instance of SQL on the server "Instance2". I got past the authentication screen, but partway through the "Setup Process", on the "SQL Server Database...

I suggested that to the Network Admin, but he doesn't want to pay. :angry:

But we might have to anyway if there's...

Eoin (12/2/2009)

---

I see a SPN error message in the posted sql logs, have you recently changed the permissions of the service accounts (or changed the accounts).

Also is the E drive...