You must create a Proxy in order to do this.

The following article addresses your issue:

http://www.mssqltips.com/sqlservertip/1199/sql-server-agent-proxies/

I had a similar issue today where I had three external users that wanted permissions to...

I followed the following steps to create a Credential, Proxy Account,etc.

I thought that it was a pretty good article.

http://www.mssqltips.com/sqlservertip/2163/running-a-ssis-package-from-sql-server-agent-using-a-proxy-account/

I found the section "Specify Proxy to Use for Job Step" to...

I found the answer. They are not available for the event that I was trying to use them for.

http://msdn.microsoft.com/en-us/library/ms141788.aspx

Thanks!

SQLKnowItAll (5/15/2012)

---

Assuming it is indexed properly, 10 million records should not be an issue. Let's say the join condition is called ID... Just do a select from the target...

SQLKnowItAll (5/15/2012)

---

Assuming it is indexed properly, 10 million records should not be an issue. Let's say the join condition is called ID... Just do a select from the target...

I got an e-mail telling me to install a Cumulative Update for SQL Server 2008 SP1.

I mentioned that I could not apply that patch becazuse we are already at SQL...

Yes Lynn. I looked up that quite some time ago but sometimes you can get that error for various reasons.

I have had to increase the Timeouts, Record Blocking size etc.

I...

Since moving two Databases and several SSIS Packages I'm having issues with the AS400 iSeries and I'm getting Communication errors.

Several task fail. It seems that the task complete much faster...

The reason that I;m not getting the correct result is due to the data being cast to character. For character data this is the expected result from the MIN/MAX functions.

CREATE...

This thread is closed.

http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=uvib3v45kbw3mheyrvqkzr45

It is close. It returns 9 as the Min value when it should be 8.

I'm using a concatenate function in Excel.

I tried to do this using the example but I'm getting a sysntax error.

SELECT 'ACCOUNT' AS TableName,'ACCOUNT_ID' AS ColumnName,

CAST(DISTINCT(TestData) AS VARCHAR(MAX)) AS DistinctValues,

MIN(CAST(TestData AS VARCHAR(MAX))) AS MinValue,MAX(CAST(TestData AS...

They slightly changed the requirements on me and unfortunately I'm not getting the right numbers.

I execute this statement:

SELECT 'ACCOUNT' AS TableName,'ACCOUNT_ID' AS ColumnName, CAST(ACCOUNT_ID AS VARCHAR(MAX)) AS DistinctValues, MIN(CAST(ACCOUNT_ID AS...

Thanks Lynn.

Your good.