Viewing 15 posts - 31 through 45 (of 237 total)
I have just had this issue where the database decided it would take its self into a "unavailable" state, after freeing up enough space on the LOG drive the database...
September 3, 2015 at 7:27 am
microsoft dynamics related - i am currently trying to figure out where they came from and came across this thread, thought i would update it for future use.
August 20, 2015 at 3:20 am
I have permission.. and I'm running the package via Visual studio trying to get it working, thats why I specified that I have permission.
July 28, 2015 at 9:14 am
Hi, I have SA on every SQL instance and Local admin on each box so permissions won't be an issue.
July 28, 2015 at 8:49 am
coolchaitu (7/23/2015)
July 24, 2015 at 4:38 am
if it is just data, no idexes etc
select * into newtable from oldtable
you can use generate scripts via the GUI to script out the table and objects if required.
July 24, 2015 at 3:54 am
Yeah why not, just remember to change your connection manager in your package to point to the live database not the dev.
July 23, 2015 at 9:45 am
Thanks for the reply, but this works fine for all of my other processing which connects to SQL 2005, SQL 2008 and SQL 2012 with the same method and connection...
July 23, 2015 at 9:39 am
OLEDB - Data Source=Server;Initial Catalog=master;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;
ADO.net - Data Source=Server;Initial Catalog=master;Integrated Security=SSPI;
July 23, 2015 at 4:01 am
just because the login does not exist does not mean people / an application won't be trying to log in using it..
July 22, 2015 at 9:18 am
Hi .
I am not sure what you mean by "running the connection string manually"
I dynamically pass the connection strings through variables from a SQL table.. but thats not the issue....
July 22, 2015 at 9:16 am
Right click SQL agent
Properties
History click remove agent history and set it to a suitable time.
You may have 'limit size of job history log' set to a low figure
July 21, 2015 at 8:52 am
If you have an active and passive node, only the active node needs to be licensed for SQL as only one node will be used at a time.
But if you...
July 21, 2015 at 8:49 am
anyone got experience with this?
Or is it just due to changes with the OLEDB connection managers from SQL 2008 - SQL 2012
July 21, 2015 at 4:34 am
Viewing 15 posts - 31 through 45 (of 237 total)