Viewing 15 posts - 1,051 through 1,065 (of 3,738 total)
When I attempt to change the Service Account and select replace the existing encyption key but it does not apply..
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/
March 26, 2013 at 12:01 pm
You should not get an error but you should include an exception Handler to Include WHEN NO DATA FOUND, perform an action.
Take you select statement and look at what is...
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/
March 26, 2013 at 8:16 am
Massan (3/25/2013)
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/
March 25, 2013 at 10:34 am
For Remote Server whether it be Oracle AS400 DB2 or whatever the Linked Server can be terribly slow.
Depending upon the amount of data you are pulling it may be 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/
March 22, 2013 at 2:58 pm
I had 64 bit set to true on many occassions and it still ran in debug but failed when running as a job.
I just ran a package with 64 bit...
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/
March 20, 2013 at 11:38 am
It's the Database!!! (3/20/2013)
It's the Database!!! (3/20/2013)
lazy writer (3/20/2013)
I had some weird issues while running SSIS package as agent job. I can run SSIS package manually but failing to run...
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/
March 20, 2013 at 11:02 am
Looking at your error message more closely it could be related to the DSN.
Consider where it is a 32 bit DSN or a 64 bit DSN.
http://sql-ution.com/32-bit-odbc-connections-with-64-bit-ssis
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/
March 20, 2013 at 10:54 am
Right Click on the Project and Select Properties,
On the left click the debugging tab.
Make sure that Run64bitRuntime is set to false.
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/
March 20, 2013 at 10:21 am
At the following URL:
http://serverfault.com/questions/291469/sql-server-wont-start-due-to-luns-being-unavailable
I found this:
Are you using the Microsoft iSCSI software initiator? Are the defined iSCSI drives dynamic?
There is a known issue where the software iSCSI initiator doesn't start...
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/
March 18, 2013 at 11:11 am
kevaburg (3/17/2013)
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/
March 17, 2013 at 7:54 am
SQLRNNR (3/14/2013)
SQLRNNR (3/13/2013)
Welsh Corgi (3/13/2013)
Seemita Das (3/13/2013)
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/
March 15, 2013 at 9:54 am
Yes you can accomplish it through SSMS. I prefer to do this in T-SQL.
To do this in SSMS.
Create a User and add them to the public role. (for minimum permissions)
If...
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/
March 14, 2013 at 1:05 pm
sankar276 (3/13/2013)
This might be helpful you.
Sorry but that issue in the article that you provided is totally unrelated to the issue that I'm having.
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/
March 14, 2013 at 6:17 am
Jeffrey Williams 3188 (3/13/2013)
If so, then your domain account running SQL Server agent does not have...
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/
March 13, 2013 at 2:03 pm
Seemita Das (3/13/2013)
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/
March 13, 2013 at 12:03 pm
Viewing 15 posts - 1,051 through 1,065 (of 3,738 total)