Viewing 15 posts - 856 through 870 (of 4,272 total)
I'm going with typo.. And really, are you worried?
CEWII
October 27, 2011 at 2:28 pm
Evil Kraig F (10/27/2011)
Elliott Whitlow (10/27/2011)
You can install SSIS without installing the database engine.
True, just still need to have equivalent licensing as though you had installed the full engine... At...
October 27, 2011 at 2:27 pm
Yes, days can be included on the value. You can test this by creating a job that just sits for a day. I have a messy formula to calculate...
October 27, 2011 at 2:18 pm
mail.lists (10/26/2011)
A contractor we had here has suggested it is never a good idea to run SSIS and your production database on the same server.
Anyone who uses always or never...
October 27, 2011 at 2:14 pm
You could certainly slam the data together but what you are looking for is more image handling. Phil is right, you need to look for an example in VB/C#...
October 27, 2011 at 2:05 pm
Excellent, I had run accross this very problem but it was 2000 -> 2005. Nothing failed, just nothing went. Nearly caused a rollback of a HUGE deployment in...
October 27, 2011 at 8:59 am
I believe the 0x80040E09 is a permission denied. What user is trying to access the database and does that user have permissions.
I also noticed you are running 2008R2 RTM,...
October 27, 2011 at 8:55 am
kstjacques (10/27/2011)
My coworker who is a senior DBA (mainly Oracle) of 20 years says...
October 27, 2011 at 8:49 am
No because you still have to overcome the database level security. And I don't think that it can be overcome with database chaining either.
CEWII
October 26, 2011 at 4:04 pm
GilaMonster (10/26/2011)
Elliott Whitlow (10/26/2011)
You do have backups?I suspect this is a interview/theoretical question (at least I hope it is)
You may be right.
CEWII
October 26, 2011 at 3:19 pm
In SQL 2000 I agree with Lynn, there is really nothing you can do but copy the data to a single database. In SQL 2005 you could probably build...
October 26, 2011 at 3:16 pm
Provided I read that right.. You are trying to get data from a SQL 2008 into a SQL 2000.
If that is correct then you have two possible...
October 26, 2011 at 2:59 pm
What are the data types of your key values? Int? Or something else?
CEWII
October 26, 2011 at 2:29 pm
In the strongest terms I would not recommed trying to do a restore of an previous version to a newer version of ANY (ANY!) system databases, which I count msdb...
October 26, 2011 at 10:20 am
Viewing 15 posts - 856 through 870 (of 4,272 total)