Swirl80 (8/20/2009)

---

We're looking towards moving everything to a virtual environment but in order for me to be fully convinced (read a lot aboput virtual sql environments being slower that physical)...

I agree - would prefer to have everything wrapped up in a function.

But the big question is how do you programmatically get to stored procedure parameters without hard...

Is that any different from what I originally posted?

Sorrry but I'm not sure I follow you? Can you provide more detail?

Sure - I know it can do be done using SQLProfiler - but whats the impact of having that running all the time in production?

I have a large number of logins that have been disabled. I would like to drop these logins and would prefer to script this. I've looked through the...

We found the problem - the PATH environment variable had been overwritten and hence DTSRUN could not be found in the path.

Sorry I dont think I was specific enough..

The DTS packages on their own run fine - ie I can run them successfully from the DTS designer or by using the...

We're running 2000 SP2. The client (VB app) is using MDAC 2.7.

I have not yet tried doing a trace. I dont think this will reveal anything as I...

You should also consider changing to a binary sort order. This will defintely give you some improvement.

hi sorry I don't quite follow - I thought distributed views were only used when you wanted to do a union type select across multiple databases/servers. How exactly do...

The main reason I am thinking of using 2 instances is that we are installing Siebel with a whole load of our other databases. I want to ensure that...

But why then does the following work:

SELECT dbo.udfTEST('sdfs')

Also why do you have to prefix the object with the owner? You dont need to do this with any other SQL...

Well I tried the suggestion - using two different linked servers but the times didnt improve. It looks as though there is defintely no multi threading going on. ...