Your connection string is probably something like:

CnnStr = "Provider=SQLOLEDB....."

Try CnnStr = "Driver={SQL Server};Server=...;DataBase=..."

You can also take a look at you COM components - if you have for instance a server-side recordset and for each record in it openning another recordset - they...

You can execute netstat -na in a command window on the server. The IP addresses next to the ServerIP:1433 will show you who (IP) is trying to connect to the...

quote:

---

My suggestions are as follows...

1. Do NOT use C# for large apps.

....

---

PhilBest,

This is off topic,...

Here is what I do:

I have all the SQL servers of interest linked to my desktop SQL server. I have a single table and a stored procedure on the same...

The SQL 7 Desktop edition will run on WinXP - make sure you install the latest SP for the SQL server.

The VB6 will run on WinXP - it is important...

If you want to address only one element of the collection - it is like this:

Set OneService = oWMIObjSet("\\ServerName\root\cimv2:Win32_Service.Name='SQLSERVERAGENT'")

As you can see it is more simple to go with For...

You can investigate what EM does when scripting objects by starting a trace and scripting the objects at the same time. You will see what SPs are being used and...

Just to add some WMI flavor here:

The script could be executed from a workstation if the user has admin rights to the box and if WMI has been installed (it...

Try the script below - it will give you the index columns and their position in the index.

Select Tables.Name As TableName,

Indexes.Name As IndexName,Keys.KeyNo,Cols.Name...

Ask for your Lan Id to be added to the local administrators group on the box - if they haven't changed the BUILTIN\Administrators login - that might give you Sysadmin...

It looks like the sp_cycle_errorlog can only be executed by the SA user - if you open the SP - there is a call to suser_id() and it should be...

Is the account member of the System Administrators role on the server ?

If you have excluded the BUILTIN\Administrators from this role, then make sure the account is member of...

Make sure that the user is member of the local administrators group and in the job properties select sa for the owner.

Make sure that the user is member of the local administrators group and in the job properties select sa for the owner.