thanks for the reply.

I want to stay away from enabling options on the server, I don't know much about 'Ole Automation Procedures'; not sure of the security implications or as...

.

This...

As in the index statistics?

Neeraj Dwivedi (1/29/2014)

---

When you say pretty much same it means identical or few things are different?

Do they have same # of processor & same amount of memory?

yeh 4 processors each....

I found a quicker way to find out that status, I query DATABASEPROPERTYEX, this gives me what I need (simply whether the database is ONLINE/OFFLINE). Now just working out how...

Dammit, this was what I didn't want. Oh well.

thanks for advice.

How do you run a DBCC Check DB against the database that is acting as a Mirror? When I try, I get the standard message saying I can't run it...

Yes, I've tried different sequences, characters (e.g. "", ' ', % etc.) but to avail.

No, not using variables. If I take either of the options out, it works but not...

I'm having the exact same issue!

My problem is that I've got round the exit code issue by this:

ROBOCOPY D:\filetocopy E:\filetocopyto ^& IF %ERRORLEVEL% LEQ 1 exit 0 /MAXAGE:1

The problem which...

Aha. So that explains what I saw when I restarted a Instance with 'Dynamic Port' allocated, the port number did not change as it wasn't being used by any other...

What would be the best way to view the execution plan, seeing how the queries are executed from the application? Would I need to replicate the process and perhaps view...

Thank you for the reply, I will look into this.

HanShi (10/2/2013)

---

Execute this command from SSMS:

exec xp_cmdshell N'whoami'

Make sure the account listed in the results has the correct permissions to execute the BCP executable and to write to the destination...

Yes, it runs in command....