Thanks, but that link does not apply in my case (I have...

My 0.2 cents on this:

If you are starting off connecting through SQL auth, save yourself the heartache and go with it all the way.

Setting up Windows auth double-hop/chaining is not...

Thanks Matt, all you are saying makes a lot of sense.

I'd also rather leverage the .NET framework.

I'll give it a try...

Thanks guys for your suggestions, I will have a look at the info provided.

Matt, I was thinking of creating a .NET console app, but I'm not sure all machines of...

Mani raises very good points.

Auditing is a must in a prod environment, as is removing BUILTIN\ADMINS from a prod instance.

SQL ORACLE (5/29/2008)

---

You may try the following DOS command. But you have to make them workable on a remote server.

at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\stop.bat"

at 6:30pm /EVERY:Monday,Tuesday,Wednesday,Thursday,Friday,Sunday "c:\start.bat"

Where stop.bat

net start mssqlserver

start.bat

net stop...

I managed to resolve this the following way.

main.bat:

checkJobsRunning.sql:

SET NOCOUNT ON

CREATE TABLE #JobStatus

(

job_id uniqueidentifier,

LastRunDate int,

LastRunTime int,

NextRunDate int,

NextRunTime int,

NextRunSchedule int,

RequestedToRunint,

Request_Source int,

Request_Source_ID varchar(100),

Running int,

CurrentStep int,

CurrentRetryAttempt...

There is no such thing for SQL 2000 unfortunately.

I'm almost there, but I'm stuck trying to pass...

Ola Hallengren (5/29/2008)

---

If you drop a database it is captured in the default trace.

Look in the trc - files that are located in the same directory as the error logs.

Ola...

Steve Jones - Editor (5/29/2008)

---

Is this a remote or local connection? You might need to set the user and password or perhaps the trusted connection switch in your command or...

I think I got it. I have to connect to an instance from the cmd line and THEN reconnect with the :CONNECT directive.

Like this:

On cmd prompt:

test.sql...

Start with who currently has db_owner/sysadmin permissions.

Hopefully not too many people...

In SSMS, right-click on the Database Mail node under Management, and pick View Database Mail Log.

This will give you a list of recent activity along with possible errors.

Ratheesh.K.Nair (5/29/2008)

---

Hi Experts,

Is there any way to know about a database which...