Viewing 15 posts - 1,441 through 1,455 (of 3,738 total)
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 15, 2012 at 1:42 pm
Lynn Pettis (5/15/2012)
Welsh Corgi (5/15/2012)
The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches ore...
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 15, 2012 at 1:13 pm
I had to delete the task and recreate and and the problem went away.
My guess is that there was some corruption.
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 14, 2012 at 5:10 pm
I had to take a time out from that package.
In one of the containers where I'm having this issue I attempted to drag all of the tasks outside the container.
"When...
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 14, 2012 at 6:53 am
Thank you Elliot.
I running it for now for I'm trying to get it loaded.
I'm not expected to work today but I would like to keep things moving.
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 12, 2012 at 3:28 pm
It turned out to be a memory issue.
Saved script to the Server and executed and it completed successfully.
Thanks for your input.
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 12, 2012 at 12:07 am
Lynn Pettis (5/11/2012)
You said if you ran it in pieces it worked. Starting with the first piece, keep expanding until you have selected the whole script.
What you suggested 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/
May 11, 2012 at 1:58 pm
It did not paste the entire script which is huge.
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 11, 2012 at 1:44 pm
ok here it his. It will probably work on your machine.
I ran it yesterday with no problem,
I had to drop all of the objects and recreate today but when 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 11, 2012 at 1:38 pm
Post removed.
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 11, 2012 at 1:19 pm
I copied the DDL to create the table but when I tried to copy & paste the SQL Statements primarily INSERT Statements it keeps hanging on me.
I have never seen...
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 11, 2012 at 1:17 pm
At the bottom of the screen there is yellow bar that includes sections for Query Completed with Errors and a warning symbol followed by the Server Name 10.1 SP1 and...
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 11, 2012 at 12:30 pm
Cool thanks Lowell.
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 11, 2012 at 11:18 am
I found it.
GRANT EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER TO Login;
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 10, 2012 at 9:05 am
nhimabindhu (5/8/2012)
consider the @[System::ContainerStartTime] as a new column in derived column transformation and while mapping into the destination table , map the modified_date column with the derived column which was...
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 8, 2012 at 2:21 pm
Viewing 15 posts - 1,441 through 1,455 (of 3,738 total)