SELECT (

SELECT COUNT(assignment)

FROM tb_DNM_1_employee

WHERE (assignment = '7') and (rank = '1')

) AS firstshift,

(

SELECT COUNT(assignment)

FROM tb_DNM_1_employee

WHERE (assignment = '8') and (rank...

It worked. Thanks for the advice.

In MSDB there is a sysdtspackages table but it won't return the information you are lookign for. If the DTS Packages are executed by SQL Server Job then you can...

Thanks. I will give this a shot.

Open Tasks Manager.

Go to Processes tab

Click View

Click Select Columns

Select the Check box PID

You will see a new column in the Processes tab called PID. The Image Name column corresponding...

In the profiler look at the ClientProcessID column. This will give the PID (ProcessorID) of the process from the client application server.

You can get more details about this process...

Thanks for correcting me Sean. I am glad you caught it.

Yes. You can do that and if Product_Number column is int/bigint you dont need to put it in quotes

SELECT Customer_Number FROM Table

WHERE Product_Number = 1

AND ...

I agree with John. This looks like a permission issue. To see SQL Agent you need to be a member of sysadmin role or a member of one of the...

Full and Transactional Log backups are not mutually exclusive. A Log backup can occur when full backup is running.

Stop the application on the source server from making these calls.

I created a role called Documenters in several databases. Then I created a login called TestDocumenter and mapped it to 3 different databases thereby creating 3 users (1 in each...

The ip address is there in the error message.

It look...

You can find from the ipaddress which server is the call comming from. Just do ping -a ipaddress. You will know the server name.

You cannot use AND clause for what you need here. Try this

SELECT Customer_Number FROM Customer_Offer

WHERE Product_Offer IN ( 'Offer2','Offer1')