Viewing 11 posts - 1 through 11 (of 11 total)
Since that you can't offert your services outside USA, is it possible to get your healtcheck script?
November 1, 2018 at 7:05 am
sqlbuddy123 (4/4/2014)
I don't rely on SSIS transfer Object\Login task as it gives lot of issues.
alright, i will do it manually. Maybe it should be another topic but what kind...
April 7, 2014 at 7:24 am
what do you mean by "If you don't mind using SSIS"? we have just finished to convert from Oracle so we havent had the chance to play with everything in...
April 4, 2014 at 8:49 am
its true that i can create everything manually on the DR server but each time i do a modification on the primary server, i need to be sure to not...
April 4, 2014 at 8:30 am
it is for DR
April 4, 2014 at 8:01 am
ok... i now see the problem. The DBCC loginfo is returning one addition column that the script doesnt know about. It's the column RecoveryUnitId. This is why i have the...
May 30, 2013 at 1:29 pm
ok... i have configured the debugger and found something new. The real line that is causing the error is this one on the second pass in the 'while loop':
insert into...
May 30, 2013 at 1:22 pm
the one i used is the one on this forum. The last one you've just posted have the error too. The same line. And if i remove the @FileName condition,...
May 30, 2013 at 12:34 pm
I use the exact same script as you have posted. I tried to find the exact line that cause the error. It's this one:
delete t from @tmpdb t where DBName...
May 30, 2013 at 11:33 am
i get an error with this script:
Column name or number of supplied values does not match table definition.
May 30, 2013 at 8:14 am
Viewing 11 posts - 1 through 11 (of 11 total)