Viewing 15 posts - 4,441 through 4,455 (of 7,191 total)
You haven't stated your exact requirements, so I can't really provide any recommendations, except to consider using SSIS instead of this.
The answers to your original two questions are:
(1) Yes, you...
June 28, 2012 at 4:11 am
Bodhan
You've posted in an SSIS forum, but it sounds as if you're trying to do everything in T-SQL. If you are indeed using SSIS, it's better to take advantage...
June 28, 2012 at 3:39 am
The error message is fairly explicit. You've got a value in your nvarchar column that can't be converted to int because it has a "D" in it. The...
June 28, 2012 at 1:49 am
What is the compatibility level of your database?
John
June 27, 2012 at 3:51 am
ksrikanth77 (6/24/2012)
http://technet.microsoft.com/en-us/library/ff182359(v=WS.10).aspx
Note
There is a change in the way the Cluster service...
June 25, 2012 at 1:35 am
Adam
In 2005, you had to create the account yourself if you didn't want it using BUILTIN\Administrators. I think the security is a bit more sophisticated in 2008, so I'm...
June 21, 2012 at 9:25 am
Happy to help, Adam. I've done a bit more digging, and, by default, the "Is Alive" check runs every 60 seconds when the cluster service connects to SQL Server and...
June 21, 2012 at 9:16 am
Schadenfreude-Mei (6/21/2012)
Our ClusterAdmin account doesnt have any access to SQL. The services are set with our domain credentials for the SQL service account..... Why would you need anything else?
So that...
June 21, 2012 at 8:29 am
ganeshkumar005 (6/19/2012)
June 20, 2012 at 4:00 am
If you can't get the error in any other way, try running a trace while you execute the maintenance plan.
John
June 20, 2012 at 3:55 am
What do you want to do with the variable in your Execute SQL task? From the information you've given, it sounds as if you need to use an input...
June 19, 2012 at 7:57 am
Yes, I noticed that only last week. The size of the trace file in Explorer is 0KB until the trace has stopped.
John
June 18, 2012 at 5:56 am
Good question. I fell for it. But I don't think we should make too many assumptions about how common the clustered primary key myth is with knowing how...
June 14, 2012 at 8:44 am
Phil Parkin (6/14/2012)
I've never been brave enough to try that option out, just in case something got 'upgraded' inadvertently 🙂
It does seem a strange name for the action. I...
June 14, 2012 at 5:21 am
You can right-click on the package in Solution Explorer and choose Reload with Upgrade. It's a bit easier than coming out of BIDS altogether.
John
June 14, 2012 at 5:03 am
Viewing 15 posts - 4,441 through 4,455 (of 7,191 total)