Viewing 15 posts - 1,411 through 1,425 (of 3,738 total)
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 6, 2012 at 10:35 am
I followed the following steps to create a Credential, Proxy Account,etc.
I thought that it was a pretty good article.
I found the section "Specify Proxy to Use for Job Step" to...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 6, 2012 at 9:42 am
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
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 29, 2012 at 11:18 am
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 29, 2012 at 11:11 am
SQLKnowItAll (5/15/2012)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2012 at 4:16 pm
SQLKnowItAll (5/15/2012)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2012 at 3:48 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 24, 2012 at 3:36 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 22, 2012 at 8:02 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2012 at 1:39 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2012 at 7:51 am
This thread is closed.
http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=uvib3v45kbw3mheyrvqkzr45
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2012 at 7:51 am
It is close. It returns 9 as the Min value when it should be 8.
I'm using a concatenate function in Excel.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2012 at 6:22 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2012 at 6:04 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2012 at 5:55 am
Thanks Lynn.
Your good.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 18, 2012 at 1:10 pm
Viewing 15 posts - 1,411 through 1,425 (of 3,738 total)