rbarryyoung (8/26/2008)

---

Okay:

do the following:

1. Start Performance Monitor.

2. Select "Counter Logs" under "Performance Logs and Alerts"

3. From the Action Menu, click "New Log Settings..."

4. Enter a name like "Disk Stats"

5. Click...

Here is a blurb from Microsoft:

Risks Associated with Cross-Database Ownership Chaining

Microsoft recommends that you disable the cross-database ownership chaining option because of the actions that highly-privileged users can perform:

•Database owners...

Yes my first thought was to create Synonyms and grant access to specific tables.

What are the risks with Cross Database Ownership Chaining? ...

I start with the obvious....

This IS a 64-bit machine and OS installation, yes?

I set the ODBC connection up.

I went to run it and got an error.

Need to run; will try it later.

Thanks a lot for helping.

How do I create an ODBC connection again? 🙂

What is a System DSN... Are you talking ODBC?

I would...

Can I have a .bat file call 4 lines?

C> runme.bat 20080101

(runme bat: )

runme1.bat %1

runme2.bat %1

runme3.bat %1

runme4.bat %1

Would this work?

Can not use xp_cmdshell.

However, you did give me an idea......

I figured it out....

The problem was this machine has no default instance, and 2 named instances.

Once I added a -s SERVER\INSTANCE to the command line...it worked.

Actually, yes that would be incredible -

I use Performance Monitor very often, and I usually have 20...

Yes, I got occupied with something else but I will review it soon.

Thx much.

So....

Step 1 would be sp_update_jobstep to change steps 2-5.

Step 2 would run Script 1

Step 3 would run Script...

Okay. I get what you're asking now. 🙂

xp_cmdshell runs from a T-SQL...

Then you don't need SQL at all ... VBScript is what you'd want. As stated earlier, you can use command line from a vbscript - wshShell.Run. Than you can schedule...