When I have worked with Linked Servers, I found creating a linked server against a database and linking it to a specific login (such as one that had limited access...

Hello there,

When I see this, it is usually when I have not added the domain account to the local admin group on the server. Also, occassionally, we have had...

I need to detect several vb .exe programs running on a sql server that update various databases on a nightly basis.

Jody

We have both SQL 7 and SQL2000 servers going here. When I need to get SQL2000 databases to SQL7 (which is the other way around) I have found it...

Some of what you are experiencing could be related to your SQL Agent. I had a few days when I was running down a similar situation just getting jobs...

Hi attilas,

I am curious about this one. It seems that you may be like many of us have been at one time and that is under the assumption that...

Thanks Andy,

The reason for the constraint drop is that the staging version of the tables we want built with relational integrity. If the data from the external source does...

We have a similar system for mainframe to sql tables in place within our organization. We use bulk inserts to load the data into staging tables and then drop...

A very simple way to get this pattern is to right click on a dts package using enterprise manager and selecting schedule a job. This will build a dtsrun...